General discussion

Locked

How to use multilingual in SQL 7.0?

By greygoose ·
For the project we have right now, we need to input Japanese into SQL. I installed Globle IME on the server already. It works fine in Word, Powerpoint, etc., but it just doesn't want to work under SQL. Also how do I maintain an SQL table with both Japanese and English characters?
It should be easy to switch to a different language if required.

Your input is appreciated.

This conversation is currently closed to new comments.

5 total posts (Page 1 of 1)  
| Thread display: Collapse - | Expand +

All Comments

Collapse -

How to use multilingual in SQL 7.0?

by Fnugry In reply to How to use multilingual i ...

SQL server supports unicode types - nchar, ntext - that allow you to store character strings in any language in the same table. Creating a table with a field in several languages is far more tricky tho (unless you want to include an extra column foreach supported language.) I guess adding 'text-tables' to the database (one for each language) and referencing to a text in the text table instead of including the text itself may solve the problem. In this case, you may need to develop a set of stored procedures to retrieve/update text fields and a couple of triggers to maintain text tables consistency.

Collapse -

How to use multilingual in SQL 7.0?

by greygoose In reply to How to use multilingual i ...

The question was auto-closed by TechRepublic

Collapse -

How to use multilingual in SQL 7.0?

by gbworld In reply to How to use multilingual i ...

In SQL Server 7.0, you have few options. The first is to set up a field in one of the n types (for Unicode). This would include nchar, ntext, etc.

In SQL Server 2000, if it is an option, you can do a lot more. For example, you can set up two columns with different collations, in the same table. While it may not be necessary to go to this extent, it is an option.

Another SQL 2000 option is to set up a federated cluster where calls in one language go to one of the servers, while those in another language go to the other.

I would suggest the nchar, nvarchar and ntext option first if you need to map to one table. You can also use this option in a multiple table set up. It would be easier to set up that even the SQL 2000 options.

GB

Collapse -

How to use multilingual in SQL 7.0?

by greygoose In reply to How to use multilingual i ...

The question was auto-closed by TechRepublic

Collapse -

How to use multilingual in SQL 7.0?

by greygoose In reply to How to use multilingual i ...

This question was auto closed due to inactivity

Back to Web Development Forum
5 total posts (Page 1 of 1)  

Related Discussions

Related Forums