Hi all,
I have Text in MySQL utf 8 and an iframe displaying this text, and the page content is utf8.
Does anybody know why the iframe caret position doesn't match with MySQL position when there are line breaks, and how to fix it?
Regards
softDeveloper
0
Junior Poster in Training
Recommended Answers
Jump to PostHow do you set the caret? And how do you measure its position? Probably your display module counts one character per line break while mysql store CR+LF, or vice versa.
All 4 Replies
smantscheff
265
Veteran Poster
How do you set the caret? And how do you measure its position? Probably your display module counts one character per line break while mysql store CR+LF, or vice versa.
softDeveloper
0
Junior Poster in Training
Hi, I saw this article:
http://breckyunits.com/code/ansi_or_ascii_and_unicode_or_utf8_and_newlines
It appears that MySQL considers '\r\n' and the iframe in JSP displays the linebreaks without '\r'. So I saved the file as UNIX EOL in Notepad++ and now it works. But both MySQL and jsp have everything in UTF-8.
smantscheff
265
Veteran Poster
But both MySQL and jsp have everything in UTF-8
And is this a problem?
softDeveloper
0
Junior Poster in Training
No, I want everything in UTF-8! The problem was '\r' that was messing up all the application
Be a part of the DaniWeb community
We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.