Home How does the SQL length function handle unicode graphemes?
Reply: 0

How does the SQL length function handle unicode graphemes?

user529
1#
user529 Published in April 23, 2018, 8:58 pm

Consider the following scenario where I have the string defined by \U00000045\U00000301.

1) https://www.fileformat.info/info/unicode/char/0045/index.htm
2) https://www.fileformat.info/info/unicode/char/0301/index.htm

Would a table constrained by varchar(1) treat it as a valid 1 character input. Or would it be rejected because it is considered a 2 character input?

How does SQL treat the length of strings with graphemes in them generally?

You need to login account before you can post.

About| Privacy statement| Terms of Service| Advertising| Contact us| Help| Sitemap|
Processed in 0.325155 second(s) , Gzip On .

© 2016 Powered by mzan.com design MATCHINFO