c# - Unicode issue with insert ZERO WIDTH SPACE into database -


i using ckeditor , seems possible correct keypresses following unicode character inserted textarea.

u+200b ​ \xe2\x80\x8b 0 width space

now when try save mysql database following error:-

mysql.data.mysqlclient.mysqlexception incorrect string value: '\xe2\x80\x8b </...' column 'content' @ row 1

from can see have several options:-

  1. change collation on table, not entirely sure impact have on c# mvc4 application uses nhibernate orm
  2. strip out unicode string before insert database, not entirely how , if correct.
  3. this seems bug in ckeditor browsers, future proof myself not waiting fix.

so question best option around issue?

table structure

visibly charset latin1.

you shouldn't try store unicode data in latin1 column. have change that:

alter table campaignemail modify content longtext character set utf8

beware when doing if erroneously stored "unicode-pretending-to-be-latin1" might put mess in table values.

btw charset encoding used map "letter" (strictly speaking: codepoint) "bytes".

the collation define relative order between various "letters". if used search/sort columns.


Comments

Post a Comment

Popular posts from this blog

matlab - Deleting rows with specific rules -

i got 20*3 cell array , need delete rows contains "137", "2" , "n:t" origin data: 't' '' '' 'np(*)' '' '' [ 137] '' '' [ 2] '' '' 'are' 'and' 'np(fcc_a1#1)' '' '' '1:t' [ 1200] [0.7052] '' [1.2051e+03] [0.7076] '' 'are' 'and' 'np(fcc_a1#3)' '' '' '2:t' [ 1200] [0.0673] '' [1.2051e+03] [0.0671] '' 'are' 'and' 'np(m23c6)' '' '' '3:t' [ 1200] [0.227...
Read more

php - MySQLi multi_query results for later use -

i using mysqli multi_query work several select statemets @ time. know how handle results, able use them later in code. example: <?php //connection stuff $query = "select name, surname database1;"; $query.= "select car, year, type database2 carid='1';"; $query.= "select product, price database3;"; if ($mysqli->multi_query($query)) { if($result = $mysqli->store_result()) { while($row = $result->fetch_row()) { --> here? } } } ?> <html> <div id='persona'> <?php foreach() { --> print name + surname } ?> </div> <div id='cars'> <?php foreach() { --> print car + year + type } ?> </div> <div id='product'> <?php foreach() { --> print product + price } ?> </div> </html> one more thing, prepared statements not possible when using multiple_query, right? there no benefit in putting unrelated queries in 1 multi ...
Read more