Posted by Roy Harvey on 01/22/07 13:49

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.

Good luck!

Roy

On 22 Jan 2007 04:59:47 -0800, "Denis" <k9kondop@hotmail.com> wrote:

>Actually I just read somewhere that you an actually define different
>collations for different columns. Have you heard anything about that?
>
>
>If that is true then I could simply stick to a default collation and
>only put the chinese or greek collation on some of the columns only.
>what do you think?

[Back to original message]