Collation problem (I use a fields used for both latin and greek character but I couldn't display greek characters)

Question

Post reply

Collation problem (I use a fields used for both latin and greek character but I couldn't display greek characters)

kejeiri

SSC Enthusiast

Points: 195
More actions
March 23, 2009 at 9:12 am

#136026

Hi,
I used a fields to store latin and greek character data... The collation of my database is set to SQL_Latin1_General_CP1_CI_AS. since I used that field to store both I couldn't see the greek character when I do a select... what am I suppose to do ot sort this mess out?...
Many thanks for the help,

Viewing 7 posts - 1 through 7 (of 7 total)

You must be logged in to reply to this topic. Login to reply

steveb. SSC-Forever Points: 46733 More actions · Answer 1

Collation does not affect how the data is stored, only how it is compared and sorted.

Are you using a UniCode column type (nChar or nVarchar)?

Are you using the prefix N when inserting the data.

Gift Peddie SSC Guru Points: 73570 More actions · Answer 2

Collation does not affect how the data is stored, only how it is compared and sorted.

Well but when you need to store Greek one of the most complex European languages you need to define the column as Greek and use collation precedence to query for the other language. Check below for details.

http://www.sqlservercentral.com/Forums/Topic655592-149-1.aspx#bm655808

http://msdn.microsoft.com/en-us/library/ms179886.aspx

Kind regards,
Gift Peddie

steveb. SSC-Forever Points: 46733 More actions · Answer 3

Gift Peddie (3/23/2009)
Collation does not affect how the data is stored, only how it is compared and sorted.
Well but when you need to store Greek one of the most complex European languages you need to define the column as Greek and use collation precedence to query for the other language. Check below for details.
http://www.sqlservercentral.com/Forums/Topic655592-149-1.aspx#bm655808
http://msdn.microsoft.com/en-us/library/ms179886.aspx

good to know, thanks .. Luckily I have never had to deal with Greek before

kejeiri SSC Enthusiast Points: 195 More actions · Answer 4

steveb (3/23/2009)
Collation does not affect how the data is stored, only how it is compared and sorted.
Are you using a UniCode column type (nChar or nVarchar)?
Are you using the prefix N when inserting the data.

I'm using a nvarchar field but I'm doing a normal insert without specifying the prefix N...

kejeiri SSC Enthusiast Points: 195 More actions · Answer 5

kejeiri (3/23/2009)
steveb (3/23/2009)
Collation does not affect how the data is stored, only how it is compared and sorted.
Are you using a UniCode column type (nChar or nVarchar)?
Are you using the prefix N when inserting the data.
I'm using a nvarchar field but I'm doing a normal insert without specifying the prefix N...

I added the N prefix to the insert query and I did a Break point in the program and I saw greek character but when I added them to the Sqlserver table (Nvarchar field and latin collation) I found a weird text like ??st?t??t? ?????f??????...

what I'm suppose to do?

Many thanks

Gift Peddie SSC Guru Points: 73570 More actions · Answer 6

I added the N prefix to the insert query and I did a Break point in the program and I saw greek character but when I added them to the Sqlserver table (Nvarchar field and latin collation) I found a weird text like ??st?t??t? ?????f??????...
what I'm suppose to do?

I posted the solution yesterday Greek and another langauge use Greek for the column collation and use collation precedence, if you find another solution I would like to know.

Kind regards,
Gift Peddie