Monday, March 26, 2012

Saving Kanji text to a SQL table

There has been a request to save Kanji text to a sql table.
Our database is SQL 2000 sp3a collated case insensitive , accent
insensitive?
Isn't there something we would need to do before we could save data in a a
different language to a table or is that not an issue.
thanks
MeenalNo special configuration is needed. Just use a Unicode data type (nchar,
nvarchar or ntext).
Hope this helps.
Dan Guzman
SQL Server MVP
"Meenal Dhody" <meenal_dhody@.hotmail.com> wrote in message
news:uluuJdwRGHA.4616@.TK2MSFTNGP10.phx.gbl...
> There has been a request to save Kanji text to a sql table.
> Our database is SQL 2000 sp3a collated case insensitive , accent
> insensitive?
> Isn't there something we would need to do before we could save data in a
> a
> different language to a table or is that not an issue.
> thanks
> Meenal
>|||Hello Meenal,
Stored the Kajikana text in an nvarchar(...) field should be all you need
to do.
Thank you,
Kent Tegels
DevelopMentor
http://staff.develop.com/ktegels/|||Thank you both - that puts my mind at ease.
Meenal
"Dan Guzman" <guzmanda@.nospam-online.sbcglobal.net> wrote in message
news:uxPnEhwRGHA.3972@.TK2MSFTNGP10.phx.gbl...
> No special configuration is needed. Just use a Unicode data type (nchar,
> nvarchar or ntext).
> --
> Hope this helps.
> Dan Guzman
> SQL Server MVP
> "Meenal Dhody" <meenal_dhody@.hotmail.com> wrote in message
> news:uluuJdwRGHA.4616@.TK2MSFTNGP10.phx.gbl...
>

No comments:

Post a Comment