mysql utf8 encoding
Hi,
I came up with one encoding problem, so maybe anyone could give ideas. On mysql database I saved records with special characters. Collation is utf8_lithuanian_ci. Everything is fine, but the problem is - when i getting utf8 text from database, counter strike can't show special symbols. It shows spaces or question marks. As we know, CS is able to show utf8 symbols from multi-langual. So how to show them from mysql? I would need to encode text directly or something ? |
Re: mysql utf8 encoding
Not sure if that makes sense, but did you try encoding the .sma to UTF-8 without BOM?
|
Re: mysql utf8 encoding
Quote:
There are still somethings what cs cant show, because they did not put that "unicode" image in game. |
Re: mysql utf8 encoding
Quote:
|
Re: mysql utf8 encoding
You cannot show certain symbols in the game and there is no workaround for that. Save the text directly without them to the SQL database or replace the special characters before showing them.
|
Re: mysql utf8 encoding
Quote:
|
Re: mysql utf8 encoding
It's Lithuanian letters ąčęėįšųūž. Cs can show it with utf8 without BOM from multi-langual.
As I know, mysql also not use BOM. It's just a simple text saved in database. Tried "SET NAMES utf8", but it doesn't change anything (it helps getting strings in utf8 format). It is possible to convert from one encoding to other through bits, but I missed that lesson in studies. What a shame :shock: Now I would need to read all this: http://en.wikipedia.org/wiki/UTF-8 :( |
Re: mysql utf8 encoding
Read my post again.
|
| All times are GMT -4. The time now is 05:49. |
Powered by vBulletin®
Copyright ©2000 - 2024, vBulletin Solutions, Inc.