column collation

Hi,
I am using C++ to develop an application to support SQL Server 2005. I have
a problem whant I use SQLColAttribute function. It only returns "Collation
Name", instead of the real column's collation name. Does any body has any
idea?
Here it is my code:
retcode = SQLColAttribute(handleSTMT,i +1,
SQL_CA_SS_COLUMN_COLLATION ,
columnCollation,
256, &nameLength, &valueInInt);
Thanks for you help.
--Lijie
I believe is not supported in SQLColAttribute

column collation

Hi,
I am using C++ to develop an application to support SQL Server 2005. I have
a problem whant I use SQLColAttribute function. It only returns "Collation
Name", instead of the real column's collation name. Does any body has any
idea?
Here it is my code:
retcode = SQLColAttribute(handleSTMT,i +1,
SQL_CA_SS_COLUMN_COLLATION ,
columnCollation,
256, &nameLength, &valueInInt);
Thanks for you help.
--LijieI believe is not supported in SQLColAttribute

Colletions for Multi lenjuage

Hello every one
Which intercalation works with multiples languages in SQL Server 2005?
or
How can I configure a collation for multiples languages?
and that order for all the languages, is possible?
Thank for any help.
Use the nchar, nvarchar, ntext data types.
Hilary Cotter
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html
Looking for a FAQ on Indexing Services/SQL FTS
http://www.indexserverfaq.com
"sqlextreme" <sqlextreme@.discussions.microsoft.com> wrote in message
news:8330C2A8-CA0A-489F-BFBB-31211B7CE259@.microsoft.com...
> Hello every one
> Which intercalation works with multiples languages in SQL Server 2005?
> or
> How can I configure a collation for multiples languages?
> and that order for all the languages, is possible?
> Thank for any help.
>
|||Thank Hilary
why nchar, nvarchar, ntext data types?
Cristián Carrasco
"Hilary Cotter" wrote:

> Use the nchar, nvarchar, ntext data types.
> --
> Hilary Cotter
> Looking for a SQL Server replication book?
> http://www.nwsu.com/0974973602.html
> Looking for a FAQ on Indexing Services/SQL FTS
> http://www.indexserverfaq.com
>
> "sqlextreme" <sqlextreme@.discussions.microsoft.com> wrote in message
> news:8330C2A8-CA0A-489F-BFBB-31211B7CE259@.microsoft.com...
>
>

Colletions for Multi lenjuage

Hello every one
Which intercalation works with multiples languages in SQL Server 2005?
or
How can I configure a collation for multiples languages?
and that order for all the languages, is possible?
Thank for any help.Use the nchar, nvarchar, ntext data types.
Hilary Cotter
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html
Looking for a FAQ on Indexing Services/SQL FTS
http://www.indexserverfaq.com
"sqlextreme" <sqlextreme@.discussions.microsoft.com> wrote in message
news:8330C2A8-CA0A-489F-BFBB-31211B7CE259@.microsoft.com...
> Hello every one
> Which intercalation works with multiples languages in SQL Server 2005?
> or
> How can I configure a collation for multiples languages?
> and that order for all the languages, is possible?
> Thank for any help.
>|||Thank Hilary
why nchar, nvarchar, ntext data types?
Cristián Carrasco
"Hilary Cotter" wrote:

> Use the nchar, nvarchar, ntext data types.
> --
> Hilary Cotter
> Looking for a SQL Server replication book?
> http://www.nwsu.com/0974973602.html
> Looking for a FAQ on Indexing Services/SQL FTS
> http://www.indexserverfaq.com
>
> "sqlextreme" <sqlextreme@.discussions.microsoft.com> wrote in message
> news:8330C2A8-CA0A-489F-BFBB-31211B7CE259@.microsoft.com...
>
>

Collations in SSAS. How should it work?

Hi SSAS gurus,

Could you tell me, please, what collation gets a new dimension (cube), that collation isn't specified in create script, from Server collation or from data base collation? In the MSDN there isn't clear information related to it.

If I create a new database from script, where only the collation of the database specified, all dimension and cubes get collation from server, but not from database.
But in the SQL Server DB Engine all the objects inherit collation from database not from server.

How can I specify the collation of the data base object in the SSAS project? Is there in UI any place to set collation of database in the project?

Analysis Server implements general mechanism of static inheritance. Object's properties not specified in the create statement are getting their values based on pre-defined defaults or based on the value of parent object.

This way, the database is going to be created with server collation and any object within database keeps inheriting the database collation.

As for the collaiton exposed in the project UI, couldnt find anywhere I could change it myself :)

Simple workaround is to add following XML tag to your %ProjectName%.database file <Collation>Latin_general</Collation>

Edward.
--
This posting is provided "AS IS" with no warranties, and confers no rights.

|||

Hi Edward,

I have following problem (probably a bug). I have spicified the collation Latin_General_Bin for the database in the database script . But the server has collation Latin_General_CI. In my script neither cubes no dimensions don't have collation specified. After script execution, all created cubes and dimesions have collation inherited from server, but not from database, es expected :-(

I have found how to set collation for the databese in UI :-(. In the BI Studio Menu Database -> Edit Database. Then in Properties window you can set collation for the database.

|||

You are probably right. This could be a bug. Though I would check one more thing.

Make sure when you are deploying, the database does not exist on the server. Deploying over existing database wouldnt change it's collation.

Edward.
--
This posting is provided "AS IS" with no warranties, and confers no rights.

|||Yes, a am sure. The database desn't exists on the target server and database script has callation set only for database, neither for cubes nor for dimensions.

Collations ... blah!

What collation setting(s) do I need to set with RebuildM to get the
SQL_Latin1_General_CP1_CI_AS collation?
3rd time going and I can't seem to set/select the right configuration.
Thanks,
MorganFound it...
Dictionary Order, case insensitive for use with 1252 Char Set.
Thanks,
Morgan
"Morgan" <mfears@.spamcop.net> wrote in message
news:ueb0z8jxDHA.2328@.TK2MSFTNGP10.phx.gbl...
> What collation setting(s) do I need to set with RebuildM to get the
> SQL_Latin1_General_CP1_CI_AS collation?
> 3rd time going and I can't seem to set/select the right configuration.
>
> Thanks,
> Morgan
>

Collations

Hi,
I'm starting to build a database that will contain English and Welsh
text. Up until now I have just used the default collation settings, and
everything has been fine - but I've only ever needed to use English.
There is also the possibility that, at some point in the future, the
database will have to handle several Arabic and Asian languages.
So, my question is what collation should I used to make the database as
future-proof as possible given the statements above? Does, for example,
the default collation actually support the Welsh alphabet? (Welsh has
four extra characters that I don't think appear in other European
languages - ?, ? and their upper case equivalents - possibly more, but I
don't actually know Welsh!) I notice that there isn't a bog-standard
"UTF-8" option in the collation list...
Lastly, does anyone have any general tips regarding multi-lingual databases?
Cheers,
Dylan Parry
http://electricfreedom.org | http://webpageworkshop.co.uk
The opinions stated above are not necessarily representative of
those of my cats. All opinions expressed are entirely your own.Hi Dylan,
Basically you collation should be the local environment where it is. So if
its in the UK it should be english etc.
With regards to your text, what you need to do is have the appropriate
datatype's for your tables.
For storing text that you would want as not only english, but another
language, instead of using a datatype of say char(10) you would use
nchar(10) this N, ensures that the type is unicode and not ANSI. Text
conversions of char can have mistakes, yet nchar represents the characters
as they should. One important note, using nchar instead of char, will
consume twice as much space as char, so just something to bear in mind.
hth
Barry Andrew
"Dylan Parry" <usenet@.dylanparry.com> wrote in message
news:460d0c87$0$761$bed64819@.news.gradwell.net...
> Hi,
> I'm starting to build a database that will contain English and Welsh
> text. Up until now I have just used the default collation settings, and
> everything has been fine - but I've only ever needed to use English.
> There is also the possibility that, at some point in the future, the
> database will have to handle several Arabic and Asian languages.
> So, my question is what collation should I used to make the database as
> future-proof as possible given the statements above? Does, for example,
> the default collation actually support the Welsh alphabet? (Welsh has
> four extra characters that I don't think appear in other European
> languages - ?, ? and their upper case equivalents - possibly more, but I
> don't actually know Welsh!) I notice that there isn't a bog-standard
> "UTF-8" option in the collation list...
> Lastly, does anyone have any general tips regarding multi-lingual
> databases?
> Cheers,
> --
> Dylan Parry
> http://electricfreedom.org | http://webpageworkshop.co.uk
> The opinions stated above are not necessarily representative of
> those of my cats. All opinions expressed are entirely your own.|||Barry Andrew Hall wrote:
> Hi Dylan,
> Basically you collation should be the local environment where it is.
> So if its in the UK it should be english etc.
Ah okay - so I should simply leave it "as is", right?

> With regards to your text, what you need to do is have the
> appropriate datatype's for your tables.
> For storing text that you would want as not only english, but another
> language, instead of using a datatype of say char(10) you would use
> nchar(10) this N, ensures that the type is unicode and not ANSI.
> Text conversions of char can have mistakes, yet nchar represents the
> characters as they should.
Right, I understand now. So instead of using "text" to store several
paragraphs of writing, I should use "ntext" - but only in places that
could contain Welsh text.

> One important note, using nchar instead of char, will consume twice
> as much space as char, so just something to bear in mind.
In much the same way as saving a text file in UTF-8 instead of
ISO-8859-1 will consume more space. That's not too much of an issue for
me, although I guess it could cause degradation in performance?
Dylan Parry
http://electricfreedom.org | http://webpageworkshop.co.uk
The opinions stated above are not necessarily representative of
those of my cats. All opinions expressed are entirely your own.|||Your right on the performance. But to be fair, if its designed solidly you
shouldnt have a thing to worry about.
Also, as you said, anything you want potentially in another language, have a
datatype of nvarchar(max) thats probably your best bet.
"Dylan Parry" <usenet@.dylanparry.com> wrote in message
news:460d1330$0$757$bed64819@.news.gradwell.net...
> Barry Andrew Hall wrote:
> Ah okay - so I should simply leave it "as is", right?
>
> Right, I understand now. So instead of using "text" to store several
> paragraphs of writing, I should use "ntext" - but only in places that
> could contain Welsh text.
>
> In much the same way as saving a text file in UTF-8 instead of
> ISO-8859-1 will consume more space. That's not too much of an issue for
> me, although I guess it could cause degradation in performance?
> --
> Dylan Parry
> http://electricfreedom.org | http://webpageworkshop.co.uk
> The opinions stated above are not necessarily representative of
> those of my cats. All opinions expressed are entirely your own.

Collations

Hi,
I'm starting to build a database that will contain English and Welsh
text. Up until now I have just used the default collation settings, and
everything has been fine - but I've only ever needed to use English.
There is also the possibility that, at some point in the future, the
database will have to handle several Arabic and Asian languages.
So, my question is what collation should I used to make the database as
future-proof as possible given the statements above? Does, for example,
the default collation actually support the Welsh alphabet? (Welsh has
four extra characters that I don't think appear in other European
languages - ŵ, ŷ and their upper case equivalents - possibly more, but I
don't actually know Welsh!) I notice that there isn't a bog-standard
"UTF-8" option in the collation list...
Lastly, does anyone have any general tips regarding multi-lingual databases?
Cheers,
--
Dylan Parry
http://electricfreedom.org | http://webpageworkshop.co.uk
The opinions stated above are not necessarily representative of
those of my cats. All opinions expressed are entirely your own.Hi Dylan,
Basically you collation should be the local environment where it is. So if
its in the UK it should be english etc.
With regards to your text, what you need to do is have the appropriate
datatype's for your tables.
For storing text that you would want as not only english, but another
language, instead of using a datatype of say char(10) you would use
nchar(10) this N, ensures that the type is unicode and not ANSI. Text
conversions of char can have mistakes, yet nchar represents the characters
as they should. One important note, using nchar instead of char, will
consume twice as much space as char, so just something to bear in mind.
hth
Barry Andrew
"Dylan Parry" <usenet@.dylanparry.com> wrote in message
news:460d0c87$0$761$bed64819@.news.gradwell.net...
> Hi,
> I'm starting to build a database that will contain English and Welsh
> text. Up until now I have just used the default collation settings, and
> everything has been fine - but I've only ever needed to use English.
> There is also the possibility that, at some point in the future, the
> database will have to handle several Arabic and Asian languages.
> So, my question is what collation should I used to make the database as
> future-proof as possible given the statements above? Does, for example,
> the default collation actually support the Welsh alphabet? (Welsh has
> four extra characters that I don't think appear in other European
> languages - ŵ, ŷ and their upper case equivalents - possibly more, but I
> don't actually know Welsh!) I notice that there isn't a bog-standard
> "UTF-8" option in the collation list...
> Lastly, does anyone have any general tips regarding multi-lingual
> databases?
> Cheers,
> --
> Dylan Parry
> http://electricfreedom.org | http://webpageworkshop.co.uk
> The opinions stated above are not necessarily representative of
> those of my cats. All opinions expressed are entirely your own.|||Barry Andrew Hall wrote:
> Hi Dylan,
> Basically you collation should be the local environment where it is.
> So if its in the UK it should be english etc.
Ah okay - so I should simply leave it "as is", right?
> With regards to your text, what you need to do is have the
> appropriate datatype's for your tables.
> For storing text that you would want as not only english, but another
> language, instead of using a datatype of say char(10) you would use
> nchar(10) this N, ensures that the type is unicode and not ANSI.
> Text conversions of char can have mistakes, yet nchar represents the
> characters as they should.
Right, I understand now. So instead of using "text" to store several
paragraphs of writing, I should use "ntext" - but only in places that
could contain Welsh text.
> One important note, using nchar instead of char, will consume twice
> as much space as char, so just something to bear in mind.
In much the same way as saving a text file in UTF-8 instead of
ISO-8859-1 will consume more space. That's not too much of an issue for
me, although I guess it could cause degradation in performance?
--
Dylan Parry
http://electricfreedom.org | http://webpageworkshop.co.uk
The opinions stated above are not necessarily representative of
those of my cats. All opinions expressed are entirely your own.|||Your right on the performance. But to be fair, if its designed solidly you
shouldnt have a thing to worry about.
Also, as you said, anything you want potentially in another language, have a
datatype of nvarchar(max) thats probably your best bet.
"Dylan Parry" <usenet@.dylanparry.com> wrote in message
news:460d1330$0$757$bed64819@.news.gradwell.net...
> Barry Andrew Hall wrote:
>> Hi Dylan,
>> Basically you collation should be the local environment where it is.
>> So if its in the UK it should be english etc.
> Ah okay - so I should simply leave it "as is", right?
>> With regards to your text, what you need to do is have the
>> appropriate datatype's for your tables.
>> For storing text that you would want as not only english, but another
>> language, instead of using a datatype of say char(10) you would use
>> nchar(10) this N, ensures that the type is unicode and not ANSI.
>> Text conversions of char can have mistakes, yet nchar represents the
>> characters as they should.
> Right, I understand now. So instead of using "text" to store several
> paragraphs of writing, I should use "ntext" - but only in places that
> could contain Welsh text.
>> One important note, using nchar instead of char, will consume twice
>> as much space as char, so just something to bear in mind.
> In much the same way as saving a text file in UTF-8 instead of
> ISO-8859-1 will consume more space. That's not too much of an issue for
> me, although I guess it could cause degradation in performance?
> --
> Dylan Parry
> http://electricfreedom.org | http://webpageworkshop.co.uk
> The opinions stated above are not necessarily representative of
> those of my cats. All opinions expressed are entirely your own.

Collation?

Can you explain me what a collation is?
"Cannot resolve the collation conflict between SQL_Latin1_General_CP1_CI_AS
and Latin1_General_CI_AS in the equal to operation.: 468"
Thanks!Per BOL, "Collations specify the rules for how strings of character data are
sorted and compared, based on the norms of particular languages and locales."
I'd suggest looking up collations on the index tab in SQL Server Books
Online. It has a detailed description.
Linchi
"Paulo" wrote:
> Can you explain me what a collation is?
> "Cannot resolve the collation conflict between SQL_Latin1_General_CP1_CI_AS
> and Latin1_General_CI_AS in the equal to operation.: 468"
> Thanks!
>
>

Collation troubles with SQLServer Express 2005

Greetings,
I installed SQL Server Express 2005 in my system, and created a simple database to store mailng addresses. The database has an email field and a name field. The data to populate the database came from an Excel file saved as a Unicode Text file containing the data as:
xxx@.somemail.com; To?o Peres yyy@.someothermail.com; Iván Cárdenas Note that this data has names with accented characters.
I then tried to import the data into the SQLServer Express with the following command:
bulk insert lista
from 'c:\temp\todas.csv'
with (
DATAFILETYPE ='widechar',
FIELDTERMINATOR =';'
)
I got the following error message:
Bulk load: DataFileType was incorrectly specified as widechar. DataFileType will be assumed to be char because the data file does not have a Unicode signature.
And the data was imported as:
xxx@.somemail.com To±o Peres yyy@.someothermail.com Ivfn C?rdenas
I tried using the DATAFILETYPE ='native' and DATAFILETYPE ='widenative' options but these caused the following error:
Msg 4866, Level 16, State 7, Line 1
The bulk load failed. The column is too long in the data file for row 1, column 1. Verify that the field terminator and row terminator are specified correctly.
Msg 7399, Level 16, State 1, Line 1
The OLE DB provider "BULK" for linked server "(null)" reported an error. The provider did not give any information about the error.
Msg 7330, Level 16, State 2, Line 1
Cannot fetch a row from OLE DB provider "BULK" for linked server "(null)".

I want to avoid re-installing the server and the Express 2005 edition does not come with the tools needed to rebuild the master database anyway (see this link).
When I type the data with the Server Management Studio Express program, I can insert the accented characters correctly.
Does anyone out there know how to deal with this problem? How do I tell SQL Server Express 2005 to insert the text from the text file and keep the accented characters as they were initially?
I will welcome any help.
Ivan.

Hi Ivan,

Are you sure you saved the spreadsheet as Unicode Text? The .csv filetype suggests you didn't - unless you manually changed it.

I tried using the data above in Excel, saving as Unicode Text and then bulk inserting and it worked fine.

Thanks

Collation setup for SQLServer2000 Standard Edition

After installing sp1 on my Windows 2003 Server I was able to install SQLServer2000, but, during installation I couldn't set up collation options for SQLServer.

I heve seen many screenshots where they say after asked for instance name I should be asked for collation setup options but I can't see them.

I don't know what should I do because my ERP needs to have the SQL_Latin1_General_CP1_C1_AS setup. Can I change this after initial installation?

Thanks in advance...

Quote:

Originally Posted by Marisol

After installing sp1 on my Windows 2003 Server I was able to install SQLServer2000, but, during installation I couldn't set up collation options for SQLServer.

I heve seen many screenshots where they say after asked for instance name I should be asked for collation setup options but I can't see them.

I don't know what should I do because my ERP needs to have the SQL_Latin1_General_CP1_C1_AS setup. Can I change this after initial installation?

Thanks in advance...

If you want to change the Server Collation, please start the installation in below manner (replacing desired Collation name). All The Best !!!

start /wait setup.exe /qb INSTANCENAME=MSSQLSERVER REINSTALL=SQL_Engine REBUILDDATABASE=1 SAPWD=test SQLCOLLATION=Latin1_General_CI_AI

collation settings for codepage 1255

Hi,
I am parsing some HTML and getting text from one of the tags encoded in 1255.
In visual studio everything looks ok, but after the text is saved to the DB,
all I can see is '?' standing for each letter.
I tryed playing around with the collation settings for that colomn, but I
just can`t seem to get it to work.
Any ideas?
Thank you in advance,
Elad.
Hi Elad,
I understand that you found that when the text encoded in 1255 was added to
the database, the letters were converted to '?'.
If I have misunderstood, please let me know.
To let me better understand your issue, I would like to know the following
questions:
1. Did you add the text by your application or manually run T-SQL statement
in Query Analyzer?
I recommend that you run the T-SQL statement in QA to see if this issue
persist.
2. Could you please give the table definition and the text content if this
issue can be reproduced in QA?
3. What is the database access provider that you used in your application?
Best regards,
Charles Wang
Microsoft Online Community Support
================================================== ===
Get notification to my posts through email? Please refer to:
http://msdn.microsoft.com/subscriptions/managednewsgroups/default.aspx#notif
ications
If you are using Outlook Express, please make sure you clear the check box
"Tools/Options/Read: Get 300 headers at a time" to see your reply promptly.
Note: The MSDN Managed Newsgroup support offering is for non-urgent issues
where an initial response from the community or a Microsoft Support
Engineer within 1 business day is acceptable. Please note that each follow
up response may take approximately 2 business days as the support
professional working with you may need further investigation to reach the
most efficient resolution. The offering is not appropriate for situations
that require urgent, real-time or phone-based interactions or complex
project analysis and dump analysis issues. Issues of this nature are best
handled working with a dedicated Microsoft Support Engineer by contacting
Microsoft Customer Support Services (CSS) at
http://msdn.microsoft.com/subscriptions/support/default.aspx.
================================================== ====
When responding to posts, please "Reply to Group" via
your newsreader so that others may learn and benefit
from this issue.
================================================== ====
This posting is provided "AS IS" with no warranties, and confers no rights.
================================================== ====
|||I actually solved this a few hours ago.
All I needed to do was add a capital N before opening the '.
That forces SQL server to save the string as unicode.
Problem solved.
Thank you!
|||Hi Eladla,
Thanks for your updating and response.
I am glad to hear that you have resolved this issue by yourself. If you
have any other questions or concerns, please feel free to let me know.
Have a good day!
Best regards,
Charles Wang
Microsoft Online Community Support
================================================== ===
Get notification to my posts through email? Please refer to:
http://msdn.microsoft.com/subscriptions/managednewsgroups/default.aspx#notif
ications
If you are using Outlook Express, please make sure you clear the check box
"Tools/Options/Read: Get 300 headers at a time" to see your reply promptly.
Note: The MSDN Managed Newsgroup support offering is for non-urgent issues
where an initial response from the community or a Microsoft Support
Engineer within 1 business day is acceptable. Please note that each follow
up response may take approximately 2 business days as the support
professional working with you may need further investigation to reach the
most efficient resolution. The offering is not appropriate for situations
that require urgent, real-time or phone-based interactions or complex
project analysis and dump analysis issues. Issues of this nature are best
handled working with a dedicated Microsoft Support Engineer by contacting
Microsoft Customer Support Services (CSS) at
http://msdn.microsoft.com/subscriptions/support/default.aspx.
================================================== ====
When responding to posts, please "Reply to Group" via
your newsreader so that others may learn and benefit
from this issue.
================================================== ====
This posting is provided "AS IS" with no warranties, and confers no rights.
================================================== ====

collation settings for codepage 1255

Hi,
I am parsing some HTML and getting text from one of the tags encoded in 1255.
In visual studio everything looks ok, but after the text is saved to the DB,
all I can see is '?' standing for each letter.
I tryed playing around with the collation settings for that colomn, but I
just can`t seem to get it to work.
Any ideas?
Thank you in advance,
Elad.Hi Elad,
I understand that you found that when the text encoded in 1255 was added to
the database, the letters were converted to '?'.
If I have misunderstood, please let me know.
To let me better understand your issue, I would like to know the following
questions:
1. Did you add the text by your application or manually run T-SQL statement
in Query Analyzer?
I recommend that you run the T-SQL statement in QA to see if this issue
persist.
2. Could you please give the table definition and the text content if this
issue can be reproduced in QA?
3. What is the database access provider that you used in your application?
Best regards,
Charles Wang
Microsoft Online Community Support
=====================================================Get notification to my posts through email? Please refer to:
http://msdn.microsoft.com/subscriptions/managednewsgroups/default.aspx#notif
ications
If you are using Outlook Express, please make sure you clear the check box
"Tools/Options/Read: Get 300 headers at a time" to see your reply promptly.
Note: The MSDN Managed Newsgroup support offering is for non-urgent issues
where an initial response from the community or a Microsoft Support
Engineer within 1 business day is acceptable. Please note that each follow
up response may take approximately 2 business days as the support
professional working with you may need further investigation to reach the
most efficient resolution. The offering is not appropriate for situations
that require urgent, real-time or phone-based interactions or complex
project analysis and dump analysis issues. Issues of this nature are best
handled working with a dedicated Microsoft Support Engineer by contacting
Microsoft Customer Support Services (CSS) at
http://msdn.microsoft.com/subscriptions/support/default.aspx.
======================================================When responding to posts, please "Reply to Group" via
your newsreader so that others may learn and benefit
from this issue.
======================================================This posting is provided "AS IS" with no warranties, and confers no rights.
======================================================|||I actually solved this a few hours ago.
All I needed to do was add a capital N before opening the '.
That forces SQL server to save the string as unicode.
Problem solved.
Thank you!|||Hi Eladla,
Thanks for your updating and response.
I am glad to hear that you have resolved this issue by yourself. If you
have any other questions or concerns, please feel free to let me know.
Have a good day!
Best regards,
Charles Wang
Microsoft Online Community Support
=====================================================Get notification to my posts through email? Please refer to:
http://msdn.microsoft.com/subscriptions/managednewsgroups/default.aspx#notif
ications
If you are using Outlook Express, please make sure you clear the check box
"Tools/Options/Read: Get 300 headers at a time" to see your reply promptly.
Note: The MSDN Managed Newsgroup support offering is for non-urgent issues
where an initial response from the community or a Microsoft Support
Engineer within 1 business day is acceptable. Please note that each follow
up response may take approximately 2 business days as the support
professional working with you may need further investigation to reach the
most efficient resolution. The offering is not appropriate for situations
that require urgent, real-time or phone-based interactions or complex
project analysis and dump analysis issues. Issues of this nature are best
handled working with a dedicated Microsoft Support Engineer by contacting
Microsoft Customer Support Services (CSS) at
http://msdn.microsoft.com/subscriptions/support/default.aspx.
======================================================When responding to posts, please "Reply to Group" via
your newsreader so that others may learn and benefit
from this issue.
======================================================This posting is provided "AS IS" with no warranties, and confers no rights.
======================================================

collation settings for codepage 1255

Hi,
I am parsing some HTML and getting text from one of the tags encoded in 1255
.
In visual studio everything looks ok, but after the text is saved to the DB,
all I can see is '?' standing for each letter.
I tryed playing around with the collation settings for that colomn, but I
just can`t seem to get it to work.
Any ideas?
Thank you in advance,
Elad.Hi Elad,
I understand that you found that when the text encoded in 1255 was added to
the database, the letters were converted to '?'.
If I have misunderstood, please let me know.
To let me better understand your issue, I would like to know the following
questions:
1. Did you add the text by your application or manually run T-SQL statement
in Query Analyzer?
I recommend that you run the T-SQL statement in QA to see if this issue
persist.
2. Could you please give the table definition and the text content if this
issue can be reproduced in QA?
3. What is the database access provider that you used in your application?
Best regards,
Charles Wang
Microsoft Online Community Support
========================================
=============
Get notification to my posts through email? Please refer to:
http://msdn.microsoft.com/subscript...ault.aspx#notif
ications
If you are using Outlook Express, please make sure you clear the check box
"Tools/Options/Read: Get 300 headers at a time" to see your reply promptly.
Note: The MSDN Managed Newsgroup support offering is for non-urgent issues
where an initial response from the community or a Microsoft Support
Engineer within 1 business day is acceptable. Please note that each follow
up response may take approximately 2 business days as the support
professional working with you may need further investigation to reach the
most efficient resolution. The offering is not appropriate for situations
that require urgent, real-time or phone-based interactions or complex
project analysis and dump analysis issues. Issues of this nature are best
handled working with a dedicated Microsoft Support Engineer by contacting
Microsoft Customer Support Services (CSS) at
http://msdn.microsoft.com/subscript...t/default.aspx.
========================================
==============
When responding to posts, please "Reply to Group" via
your newsreader so that others may learn and benefit
from this issue.
========================================
==============
This posting is provided "AS IS" with no warranties, and confers no rights.
========================================
==============|||I actually solved this a few hours ago.
All I needed to do was add a capital N before opening the '.
That forces SQL server to save the string as unicode.
Problem solved.
Thank you!|||Hi Eladla,
Thanks for your updating and response.
I am glad to hear that you have resolved this issue by yourself. If you
have any other questions or concerns, please feel free to let me know.
Have a good day!
Best regards,
Charles Wang
Microsoft Online Community Support
========================================
=============
Get notification to my posts through email? Please refer to:
http://msdn.microsoft.com/subscript...ault.aspx#notif
ications
If you are using Outlook Express, please make sure you clear the check box
"Tools/Options/Read: Get 300 headers at a time" to see your reply promptly.
Note: The MSDN Managed Newsgroup support offering is for non-urgent issues
where an initial response from the community or a Microsoft Support
Engineer within 1 business day is acceptable. Please note that each follow
up response may take approximately 2 business days as the support
professional working with you may need further investigation to reach the
most efficient resolution. The offering is not appropriate for situations
that require urgent, real-time or phone-based interactions or complex
project analysis and dump analysis issues. Issues of this nature are best
handled working with a dedicated Microsoft Support Engineer by contacting
Microsoft Customer Support Services (CSS) at
http://msdn.microsoft.com/subscript...t/default.aspx.
========================================
==============
When responding to posts, please "Reply to Group" via
your newsreader so that others may learn and benefit
from this issue.
========================================
==============
This posting is provided "AS IS" with no warranties, and confers no rights.
========================================
==============

Collation settings for a website in Russian

I am using html, vbscript, asp and sql server.
The website is mainly in Russian but may have some English.
The consensus appears to be that it is best to use utf-8, so I plan to use
html charset utf-8, asp codepage 65001 and ntext, nchar and nvarchar
character
types.
If the above is correct, what collation should I use in SQL Server?
Thanking you in anticipation.
Posted Via webservertalk.com Premium Usenet Newsgroup Services
** SPEED ** RETENTION ** COMPLETION ** ANONYMITY **
http://www.webservertalk.com
It all depends on what type of data you are storing and is it
case-sensitive/case-insensetive in the DB. Run the following query and
will explain you each collation usage.
SELECT *
FROM ::fn_helpcollations()
-SAI

Collation settings for a website in Russian

I am using html, vbscript, asp and sql server.
The website is mainly in Russian but may have some English.
The consensus appears to be that it is best to use utf-8, so I plan to use
html charset utf-8, asp codepage 65001 and ntext, nchar and nvarchar
character
types.
If the above is correct, what collation should I use in SQL Server?
Thanking you in anticipation.
Posted Via mcse.ms Premium Usenet Newsgroup Services
----
** SPEED ** RETENTION ** COMPLETION ** ANONYMITY **
----
http://www.mcse.msIt all depends on what type of data you are storing and is it
case-sensitive/case-insensetive in the DB. Run the following query and
will explain you each collation usage.
SELECT *
FROM ::fn_helpcollations()
-SAI

Collation settings for a website in Russian

I am using html, vbscript, asp and sql server.
The website is mainly in Russian but may have some English.
The consensus appears to be that it is best to use utf-8, so I plan to use
html charset utf-8, asp codepage 65001 and ntext, nchar and nvarchar
character
types.
If the above is correct, what collation should I use in SQL Server?
Thanking you in anticipation.
Posted Via Usenet.com Premium Usenet Newsgroup Services
----
** SPEED ** RETENTION ** COMPLETION ** ANONYMITY **
----
http://www.usenet.comIt all depends on what type of data you are storing and is it
case-sensitive/case-insensetive in the DB. Run the following query and
will explain you each collation usage.
SELECT *
FROM ::fn_helpcollations()
-SAI

Collation setting

Hi
We have a sqlserver 2005 DB which is mainly used by sharepoint. We are
using "Latin1_General_CI_AS_KS_WS" collation for SharePoint Portal Server
2003 databases. When I have installed the server I have installed
"Latin1_General_CI_AS
" collation which is the default collation setting for canada.
So now we have different collation settings for the the system databases and
sharepoint databases. Which collation setting should I keep?
Thanks
--
ontario, canadaI would go with the default collation (sort id 52) that is
SQL_Latin1_General_CP1_CI_AS. (This depends on what your need)
However, in your current situation it appears that your databases are using
a different collation and the server is installed using a different
collation. you can do one of the following things:
1) Change the collation at the database level to match the collation of the
server.
2) Change the collation at the server level. (recommended)
Take a look at this tip on how to change the collation at the server level:
http://www.sqlcommunity.com/SQLTips/tabid/77/grm2id/21/Default.aspx
--
Thank you,
Saleem Hakani
HTTP://WWW.SQLCOMMUNITY.COM (World Wide SQL Server Community)
SQLTips, Scripts, Discussions, Blogs, Articles, Radio and a lot of SQL
Server Fun.
"db" wrote:
> Hi
> We have a sqlserver 2005 DB which is mainly used by sharepoint. We are
> using "Latin1_General_CI_AS_KS_WS" collation for SharePoint Portal Server
> 2003 databases. When I have installed the server I have installed
> "Latin1_General_CI_AS
> " collation which is the default collation setting for canada.
> So now we have different collation settings for the the system databases and
> sharepoint databases. Which collation setting should I keep?
> Thanks
> --
> ontario, canada|||On Oct 4, 5:40 pm, db <d...@.discussions.microsoft.com> wrote:
> Hi
> We have a sqlserver 2005 DB which is mainly used by sharepoint. We are
> using "Latin1_General_CI_AS_KS_WS" collation for SharePoint Portal Server
> 2003 databases. When I have installed the server I have installed
> "Latin1_General_CI_AS
> " collation which is the default collation setting for canada.
> So now we have different collation settings for the the system databases and
> sharepoint databases. Which collation setting should I keep?
>
Sharepoint's Collation.
If Sharepoint is the only application that server serves, then it
would be better
you rebuild the server with Sharepoint's collation. If the server
serves other
applications too, then you can maintain the server with multiple
collations,
but this is a risky business.
Regards,
Sasi.
> Thanks
> --
> ontario, canada|||Thanks saleem and sasiraj. What is the difference between
"Latin1_General_CI_AS_KS_WS" and "Latin1_General_CI_AS" collation.
ontario, canada
"sasiraj" wrote:
> On Oct 4, 5:40 pm, db <d...@.discussions.microsoft.com> wrote:
> > Hi
> > We have a sqlserver 2005 DB which is mainly used by sharepoint. We are
> > using "Latin1_General_CI_AS_KS_WS" collation for SharePoint Portal Server
> > 2003 databases. When I have installed the server I have installed
> > "Latin1_General_CI_AS
> > " collation which is the default collation setting for canada.
> >
> > So now we have different collation settings for the the system databases and
> > sharepoint databases. Which collation setting should I keep?
> >
> Sharepoint's Collation.
> If Sharepoint is the only application that server serves, then it
> would be better
> you rebuild the server with Sharepoint's collation. If the server
> serves other
> applications too, then you can maintain the server with multiple
> collations,
> but this is a risky business.
> Regards,
> Sasi.
> > Thanks
> > --
> > ontario, canada
>
>|||db wrote:
> Thanks saleem and sasiraj. What is the difference between
> "Latin1_General_CI_AS_KS_WS" and "Latin1_General_CI_AS" collation.
The difference is unimportant for most parts of the world (except
Asia). Latin1_General_CI_AS_KS_WS is Kana-sensitive and
Width-sensitive. The Latin1_General_CI_AS is much more common, because
it's the default in most installations.
"Kana-sensitive" means that it distinguishes between the two types of
Japanese kana characters: Hiragana and Katakana. If this option is not
selected, SQL Server considers Hiragana and Katakana characters to be
equal for sorting purposes.
"Width-sensitive" means that it distinguishes between a single-byte
character and the same character when represented as a double-byte
character. If this option is not selected, SQL Server considers the
single-byte and double-byte representation of the same character to be
identical for sorting purposes. In this context, double-byte characters
does not reffer to Unicode characters in general. It reffers to
Double-Byte Character Sets, such as Shift-JIS, GB2312, etc.
--
Razvan Socol
SQL Server MVP

Collation Sequence questions

Hi,

i have several questions about collation sequence i hope you guys will be able to help me with.

First :
If i have a collaction, let's say French_BIN ou SQL_Latin1_General_CP1_CI_AS, how do i know how to understand it ? I mean, is it Case Sensitive, Binary sort, Which page code, ... ?

Second :
I have 2 Databases. One using a collation X another using a collation Y.
I want to export the tables (data + keys) from one Database to another.
As far as i've noticed, not only tables are exported, but so is the collation. The result ? The two Databases appear to be using collation X. Am i missing something ?1. For French collation the code page is default 1252, refer to books online for more information.

BOL refers SQL Server supports having multiple, language-specific copies of the error messages stored in master.dbo.sysmessages. All instances of SQL Server contain the set of English messages. SQL Server is localized, or translated, into French, German, Spanish, and Japanese versions. Installations of localized versions of SQL Server install the translated set of messages in addition to the English set. When SQL Server sends a message to a connection, it uses the localized message if the language ID of the connection matches one of the language IDs present in sysmessages. If there is no message in sysmessages with the same language ID, the English version of the message is sent.

1988-2002 Microsoft Corporation. All Rights Reserved.

2. From SQL 2000 you can have column/table/database wide collation settings. So if you export the X collation to a Y collation database, only exported table will have X collation but not on database. Still it permits Y collation on database level, but X collation on table level.

Refer to books online for all kind of information about Collations.

HTH|||How can I transform the collation of an exported base?
In the properties,we don't have any more access to the list of collation,|||In SQL 2K you can change collation by using ALTER DATABASE... ALTER TABLE ... ALTER COLUMN on the database.|||How can I make the tables inherit of the database properties when I make an alter database?|||If you affect the collation to DATABASE level, the new data will be affected but not the existing data. To do so you should use ALTER TABLE to do on table level.

Do refer to Books online for COLLATION and other information.|||thanks for all

Collation Sequence Incompatibilities in ODBC

We are getting the following errors when running our application on a new database server that has a default collation sequence different from the server we developed the application on.

We are using SQL_Latin1_General_CP1_Cl_AS on our dev box, but some production boxes may not have this collation sequence since some of our clients are international.

The database itself uses this sequence and show this sequence even on the other server. If we restore the database on a server with this sequence the problem disappears, but that is not always an option.

I want to figure out how to bypass it, by either altering the collation sequence of the database or something else. In short I have to figure out how to make it work in their environment. Any ideas are much appreciated. Thanks. -- Henry :-)

P.S. I checked Microsoft and know that the issue exists. The only article I could find had to do with SMS and their recommendation of installing on a server with a different collation sequence does not resolve my problem. I can't always do that.
Our application is written in Cold Fusion 5.0

============ Error Messages ============

Error Occurred While Processing Request
Error Diagnostic Information
ODBC Error Code = 37000 (Syntax error or access violation)

[Microsoft][ODBC SQL Server Driver][SQL Server]Cannot resolve
collation conflict for equal to operation.

Error Occurred While Processing Request
Error Diagnostic Information

System Error &H80004005 (-2147467259).

===================================While this does not directly address the issue (My guess is both installs are 7.0?), perhaps your issue would be addressed by Sql Server 2k features. Sql Server 2k supports collation configurations somewhat differently from 7.0 i.e.(Sql Server 2K should support installing a server instance with a given collation and sucessfully hosting DBs with a variety of different collation configurations). It may be worth your while to test Sql Server 2k against your specific application(s) collation requirements.|||No. Both installs are SQL Server 2000. At least one is service pack 2.|||No. Both installs are SQL Server 2000. At least one is service pack 2.

S1 Then you must know about / have attempted using the tsql collation clause in queries (to force character string expressions which may include columns to apply a particular collation cast)? While one might have to add the clause to numerous queries and tsql statements in application code or withing stored procs, views, etc., the advantage of this approach is that the DB itself is not changed. You might want to isolate some problem code on a test restore configuration to get a better idea of how involved the approach may be.

S2 Another option may be (as you mentioned) to use Alter Table on the tables of the restored DB (on the target) to make it compatible with the applications in the locale where it is restored. Have you tested the results with this approach using a development test install / DB restore setup?

S3 I suggest keeping service packs and hotfixes the same accross installations (if for nothing else, to eliminate added vairables in addressing possible issues).