Psst! Did you know DevelopmentNow is a mobile web site design agency?

Contact us for help mobilizing your site, or to sign up for our beta Mobile Web SDK!
all groups > sqlserver server > february 2006 >

sqlserver server : collation


P Platan
2/28/2006 12:00:00 AM
Hi!

I am having a problem concerning collations.
I have an SQL Server 2000 with Latin1_General_CI_AS
which contains the company data.Some of the fields are Greek and although I
cannot view them correctly in the Query Analyzer , the tool we are using
(powerbuilder) displays them OK.

now that w e want to go Internet we are facing problems with the Greek
fields not displayes correctly...
What can we do in order to have them displayed correctly?

Thanx in advance!

Uri Dimant
2/28/2006 12:00:00 AM
Hi
Do you define the column which displays the database as NAVARCHAR(n)?



[quoted text, click to view]

P Platan
2/28/2006 12:00:00 AM
unfortunately no!
it is an old database.migrated from ASA...



[quoted text, click to view]

Uri Dimant
2/28/2006 12:00:00 AM
Well. please read article aboit UNICODE in the BOL

If so, you are going to alter the table and change the datatype



[quoted text, click to view]

P Platan
2/28/2006 12:00:00 AM
thanx!!

...what is BOL?

and if I alter the table will I be able to have the already stored Greek
fields displayed correctly?

[quoted text, click to view]

Uri Dimant
2/28/2006 12:00:00 AM
[quoted text, click to view]
Books On Line

[quoted text, click to view]

Yes, read the article in the BOL


[quoted text, click to view]

AddThis Social Bookmark Button