August 20, 2008 at 9:29 am
I have a column that is NText that may contain Kanji and English text.
When I view through the GUI, it shows both.
When I view in SQL it shows Kanji characters as ?
If I copy and paste from gui to update sql, same.
I did some research an it appears that notepad and sql have the same quirk which makes me think they adhere to an ansi text standard which negates non standard characters.
If I paste into word, outlook or UI via Internet Explorer all is good, Kanji and English are zen.
The question I have:
Is there a way to make below show using TSQL?
This is a test ticket for Japanese characer.
これはテストです。
これは テスト です。
これは☆ です。
これは星です。
これは12345678です。
これは12345678abcdefghです。
Currently the db shows this as:
This is a test ticket for Japanese characer.
?????????
??? ??? ???
???? ???
???????
???12345678???
???12345678abcdefgh???
August 21, 2008 at 7:17 am
The ????'s are actually squares in the db, but I had to save txt file so that when I copied into this, it would not show Kanji.
Has anyone run into this or have any ideas?
Thanks
August 28, 2008 at 2:11 am
Hi use NVARCHAR instead of VARCHAR because it has unicode
Like this
SELECT CAST('???? ???' AS NVARCHAR(MAX))
-- ???? ???
SELECT CAST(N'???? ???' AS NVARCHAR(MAX))
-- '???? ???'
SELECT N'???? ???'
-- '???? ???'
_____________________________________________
[font="Comic Sans MS"]Quatrei Quorizawa[/font]
:):D:P;):w00t::cool::hehe:
MABUHAY PHILIPPINES!
August 28, 2008 at 10:54 am
Thanks!! I will try and let you know.
August 28, 2008 at 2:32 pm
DUDE!!!!!!
YOU SO ROCK!!!!
Slight mod and all is Kewliossssss
select
cast(field as nvarchar(max))
from table
where sequence=value
Thank you very much.
August 28, 2008 at 7:44 pm
😀 Wow thanks for that reply! 😀
_____________________________________________
[font="Comic Sans MS"]Quatrei Quorizawa[/font]
:):D:P;):w00t::cool::hehe:
MABUHAY PHILIPPINES!
Viewing 6 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply