|
|
Posted by Denis on 01/22/07 14:53
> Yes, you can control the collation at the column level. It is all in
> the Books On Line. That requires either three columns instead of
> one, or three tables instead of one, with the corresponding changes to
> the application to work that way, but it certainly will work. Unicode
> nchar and nvarchar are also at the column level, and perhaps would
> allow the application to be a bit simpler as there would only be one
> version of each column in one version of the table.
thank you for your prompt reply.
What do you mean it "requires either three columns" ? I didn;t come
across any such info. What do you mean exactly?
what I want to do is the following:
TABLE A
---------------
Col1 (English) , Col2(Greek) , Col3 (Chinese)
where....
English: Default Collation
Greek: GREEK Collation
English: CHINESE Collation (or Unicode)
Since I can define collation for the 3 different columns, The question
is: Do i define the chinese/greek columns as UNICODE, or as Chinese
& Greek respectively? I was thinking the later, because the data
will take up less space and I will also have more room in the fields.
What do you think?
Navigation:
[Reply to this message]
|