It's all about the answers!

Ask a question
QuestionsTagsUsersBadges
Guidelines | FAQ
Follow this question
Question details

×1,305

question asked: May 28 '10, 2:49 p.m.
question was seen: 6,614 times
last updated: May 28 '10, 2:49 p.m.

Related questions

Installation with SQL Server

0
Luis Ennser (16●7●5) | asked May 28 '10, 2:49 p.m.
We are installing RAM with SQL2005 the documentarion states that we need to create the database with a collation sequence that ends with_BIN2 (for example, Latin1_General_BIN2).

The customer created the database with Latin1_General_CP1_AS.

Will this work? Or will we have problems?

Thx

4 answers

Most liked answers ↑|Newest answers|Oldest answers

0
permanent link
Rich Kulp (3.6k●3●8) | answered Jun 01 '10, 1:57 p.m.
FORUM MODERATOR / JAZZ DEVELOPER
On 5/28/2010 2:53 PM, ennser wrote:
We are installing RAM with SQL2005 the documentarion states that we
need to create the database with a collation sequence that ends
with_BIN2 (for example, Latin1_General_BIN2).

The customer created the database with Latin1_General_CP1_AS.

Will this work? Or will we have problems?

Thx


No it won't work. It is specific that it needs to be BIN2.
0
permanent link
Ben Tran (16) | answered Jun 02 '10, 10:03 a.m.

No it won't work. It is specific that it needs to be BIN2.


Rich,

Could you please provide more details why RAM only takes BIN2?
0
permanent link
Ben Tran (16) | answered Jun 02 '10, 10:33 a.m.
Is there any impact on not using BIN2? Will RAM still function without BIN2?
0
permanent link
Rich Kulp (3.6k●3●8) | answered Jun 02 '10, 12:36 p.m.
FORUM MODERATOR / JAZZ DEVELOPER
On 6/2/2010 10:38 AM, modernix wrote:
Is there any impact on not using BIN2? Will RAM still function without
BIN2?


As I said before, it will not work! It is very specific. We require it
to be BIN2 to enable NLS UTF character sets to work correctly. Without
it characters can get corrupted or will not sort correctly causing
invalid results.

Rich

Your answer

Register or to post your answer.


Dashboards and work items are no longer publicly available, so some links may be invalid. We now provide similar information through other means. Learn more here.