Greek/Russian characters

[navshiv]

Hi

Wondered if anybody could help. My SQL skills are not exactly advanced so any help would be appreciated.

We have our transactional systems on the iseries and we bring all the data we need for reporting into SQL Server. Soon we will be bringing Russia and Greece onto the system and one of their requirements is to show certain information in their local language. I take it it is possible for a table to have columns in multiple languages? What changes do I need to make in SQL to read Russian/Greek characters?

I can read these characters on a green screen (after some changes to settings) but when I preview data in a DTS package it's not interpretting it properly. Might this be an ODBC setting e.g. code page?

As I said, any help would be much appreciated.

Cheers

 

[vongrunt]

> I take it it is possible for a table to have columns in multiple languages?

Table can have different columns in different "languages". Problem is, between Russian, Greek and your primary language (whatever it is) there is a good chance for collation conflicts to happen. Have you tried Unicode data types?

------
"There's a man... He's bald and wears a short-sleeved shirt, and somehow he's very important to me. I think his name is Homer."
(Jack O'Neill, Stargate)

 

[navshiv]

Primary language on the table is english.

Unicode data types? These are.....

 

[vongrunt]

N-this, n-that (nchar, nvarchar, ntext).

------
"There's a man... He's bald and wears a short-sleeved shirt, and somehow he's very important to me. I think his name is Homer."
(Jack O'Neill, Stargate)

 

[navshiv]

Thanks. Wouldn't have to set a specific code page then? Or colloation on the column itself?