Forum » Programiranje » [mysql] charset
[mysql] charset
korenje3 ::
A kdo ve zakaj mi to ne dela?
mysql> insert into Users (`Priimek`) values (`črkšće`);
ERROR 1300 (HY000): Invalid utf8 character string: '\xE8rk\xB9\xE6e'
v čem je fora? table in column imam charset=cp1250 in collation=cp1250_general_ci
Problem je ker mi ne dela tudi z visual basic. v VB sem nastavil locale za dataset in datatable na sl-SI če ima to kakšno vlogo... in problem je ko naredim column, ga ne morem več zbrisat ker mi vrne kar neke čudne znake.
kako rešim ta problem?
mysql> insert into Users (`Priimek`) values (`črkšće`);
ERROR 1300 (HY000): Invalid utf8 character string: '\xE8rk\xB9\xE6e'
v čem je fora? table in column imam charset=cp1250 in collation=cp1250_general_ci
Problem je ker mi ne dela tudi z visual basic. v VB sem nastavil locale za dataset in datatable na sl-SI če ima to kakšno vlogo... in problem je ko naredim column, ga ne morem več zbrisat ker mi vrne kar neke čudne znake.
kako rešim ta problem?
i9-12900k; 32GB DDR5-6000 CL36; Nvidia RTX 3080 ti;
Gigabyte Aorus z690 master; Be Quiet Dark Power 12 1000W
Gigabyte Aorus z690 master; Be Quiet Dark Power 12 1000W
korenje3 ::
Sem dal vse tole na cp1250, pa še zmeri ne dela... v bistvu mi zdej vse šumnike kaže v redu, razen ČĆ kjer mi jih spreminja v C
mysql> SHOW VARIABLES LIKE 'character_set%';
+--------------------------+----------------------------+
| Variable_name | Value |
+--------------------------+----------------------------+
| character_set_client | utf8 |
| character_set_connection | cp1250 |
| character_set_database | latin1 |
| character_set_filesystem | binary |
| character_set_results | utf8 |
| character_set_server | latin1 |
| character_set_system | utf8 |
mysql> SHOW VARIABLES LIKE 'character_set%';
+--------------------------+----------------------------+
| Variable_name | Value |
+--------------------------+----------------------------+
| character_set_client | utf8 |
| character_set_connection | cp1250 |
| character_set_database | latin1 |
| character_set_filesystem | binary |
| character_set_results | utf8 |
| character_set_server | latin1 |
| character_set_system | utf8 |
i9-12900k; 32GB DDR5-6000 CL36; Nvidia RTX 3080 ti;
Gigabyte Aorus z690 master; Be Quiet Dark Power 12 1000W
Gigabyte Aorus z690 master; Be Quiet Dark Power 12 1000W
krho ::
popravi vsaj še: character_set_database,
si.Mail odprto-kodni odjemalec elektronske pošte. - http://www.simail.si
Uredite si svojo zbirko filmov, serij in iger - http://xcollect.sf.net
Uredite si svojo zbirko filmov, serij in iger - http://xcollect.sf.net
korenje3 ::
sej sem dal vse na cp1250... pa še zmeraj neki spreminja č na c.
i9-12900k; 32GB DDR5-6000 CL36; Nvidia RTX 3080 ti;
Gigabyte Aorus z690 master; Be Quiet Dark Power 12 1000W
Gigabyte Aorus z690 master; Be Quiet Dark Power 12 1000W
Vredno ogleda ...
| Tema | Ogledi | Zadnje sporočilo | |
|---|---|---|---|
| Tema | Ogledi | Zadnje sporočilo | |
| » | C# - MySQL - šumnikiOddelek: Programiranje | 2152 (2051) | Matthew |
| » | utf-8 in dolzina polja v mysqlOddelek: Izdelava spletišč | 3681 (3431) | tmz |
| » | [PHP] charter set windows-1250Oddelek: Programiranje | 2833 (2833) | Blisk |
| » | MySQL in šumnikiOddelek: Programiranje | 3068 (2839) | darkolord |
| » | MySQL in czsOddelek: Izdelava spletišč | 3617 (2707) | krho |