Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
ptalkad
Starting Member
4 Posts |
 Posted - 2008-01-17 : 20:08:32
|
hi,I'm trying to write from my java application into the database. The user can input any english character or any Maori Macron - Maori has 5 characters in a, e, i, o and u. My database is unable store these Maori macrons into the tables  . Can anyone guide me on this please. thanks. |
|
|
jezemine
Master Smack Fu Yak Hacker
2886 Posts |
Posted - 2008-01-17 : 21:23:46
|
are these characters unicode? if so you can store them in nchar/nvarchar/ntext columns.
elsasoft.org |
 |
|
|
ptalkad
Starting Member
4 Posts |
Posted - 2008-01-21 : 16:50:33
|
| thanks jezemine, but that would involve rebuilding the db and may lead to performance issues once db grows huge(since 2 bytes are used by nvarchar instead of the 1 byte by varchar). is there any other global setting that I could set to acheive this ? thanks,ptalkad |
|
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2008-01-21 : 18:21:06
|
| Create db with proper collation. |
|
|
|
jezemine
Master Smack Fu Yak Hacker
2886 Posts |
Posted - 2008-01-21 : 18:21:58
|
well, if you want to store unicode, you have to use the "n" types.
elsasoft.org |
|
|
|
|
|
|
Maori character support in the db