I have a database where the name of many people lay in. The character set is ISO8859-15 so western europe characters. Now I want Names from all over the world join the database,e.g. Chinese and greek characters should be usable. What do I have to change? Which Character Set do I have to use?
Asked
Active
Viewed 47 times
0
-
1Use nchar or nvarchar data type. – jarlh Apr 04 '18 at 07:32
1 Answers
3
I'm pretty sure you want Unicode character encoding.
https://en.wikipedia.org/wiki/Unicode
"ISO 8859-1 is a single-byte encoding that can represent the first 256 Unicode characters."
Alexander Kleinhans
- 5,950
- 10
- 55
- 111
-
Basically, you are right. But, Unicode is a character set. It has many character encodings. NCHAR and NVARCHAR use the UTF-16 encoding. Some RDBMSes support UTF-8 and/or UTF-8 with the BMP subset of Unicode in CHAR and VARCHAR. – Tom Blodget Apr 04 '18 at 23:13