Japanese characters convert in sql 2016
-
what is the best solution to convert to Japanese characters, I already have data in table and have requirement for people enter in Japanese.Thank you
-
What is the data type and collation(s) used in existing table(s)?
_____________
Code for TallyGenerator -
Convert what? You haven't really explained an issue.
If you use NVARCHAR() data types and a Japanese collation, you can have data inserted and queried in Japanese language.
CREATE TABLE Japanese
( id INT NOT NULL CONSTRAINT JapanesePK PRIMARY KEY
, MyData NVARCHAR(1000) COLLATE Japanese_CI_AI_KS_WS
)
GO
INSERT dbo.Japanese
(
id,
MyData
)
VALUES
(1,N'???????')
GO
SELECT j.id,
j.MyData
FROM dbo.Japanese AS j
-
Apologies, apparently this forum is storing the data in varchar, so you can't see this, but here's what I wrote:
-
Japanese characters (double-byte) in SQL
-
You still haven't described the problem you are facing.
Do you have existing none unicode data that must be convert to Japanese?
Do you now have a requirement to store unicode and non-unicode data in the same table?
Converting existing data is going to need someone to manually translate the original text and create the Japanese text and perform an update.
If you need to store unicode and non-unicode then you need to alter the column to be NVARCHAR instead of VARCHAR.
Viewing 6 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply