Jump to content

UTF8 Problem in Gridlist


ahmedo01

Recommended Posts

Hello all,

I have problem with gridlists.

Here is my table.

d9BRFdj.png

In my mysql table, it s supports turkish special characters but when i get data from table to gridlist it not supports turkish characters it shows ?? for turkish characters.

How can i fix it? Which collation i need to select? Or it is gridlist bug?

Thanks for help.

Link to comment

Try using HTML numeral entities with in the database, in conjunction with the following function to unescape it:

function unescape(str) 
  str = string.gsub( str, '<', '<' ) 
  str = string.gsub( str, '>', '>' ) 
  str = string.gsub( str, '"', '"' ) 
  str = string.gsub( str, ''', "'" ) 
  str = string.gsub( str, '(%d+);', function(n) return string.char(n) end ) 
  str = string.gsub( str, '(%d+);', function(n) return string.char(tonumber(n,16)) end ) 
  str = string.gsub( str, '&', '&' ) -- Be sure to do this after all others 
  return str 
end 
--Source: [url=http://stackoverflow.com/questions/14899734/unescape-numeric-xml-entities-with-lua]http://stackoverflow.com/questions/1489 ... s-with-lua[/url] 

Link to comment

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
  • Recently Browsing   0 members

    No registered users viewing this page.

×
×
  • Create New...