My Problem : I am using SQL server 6.5 as backend for storing data. I have a table with a field of length 20.
In case of English SQL Server I can store 20 english characters. But in case of Japanese SQL server for the
same table I can only store maximum of 10 Japanese characters.
My question is
1) how to handle the problem in both the SQL
servers without changing the data length so that I can store 20 characters.My requirement is to use same table
creation scripts for both the servers.