mysql - wrong collation for column -

-

i have legacy system running mysql 5.0.67. columns collation set latin1_swedish_ci. php scripts data db , generates page charset=windows-1257. in php page language specific characters shown correctly. when directly db data can see these characters not shown properly. see rûta instead of rūta, agnë instead of agnė. can't write database or change parameter.

when run

select a.name collate cp1257_general_ci agent

i error

collation 'cp1257_general_ci' not valid character set 'latin1'

how data db proper characters?

edit:

show variables '%char%'; character_set_client    latin1 character_set_connection    latin1 character_set_database  cp1257 character_set_filesystem    binary character_set_results    character_set_server    latin1 character_set_system    utf8 character_sets_dir  /usr/local/share/mysql/charsets/

and 

show variables 'collation%'; collation_connection    latin1_swedish_ci collation_database  cp1257_lithuanian_ci collation_server    latin1_swedish_ci

checkout if getting latin1 from

mysql> show variables '%char%';

then, in mysql configuration (my.cnf) add following lines, , restart mysql server

[mysqld]     character-set-server = utf8 collation-server = utf8_general_ci character-set-client-handshake = false

finally check getting from

mysql> show variables 'collation%';

for reference :

http://dev.mysql.com/doc/refman/5.6/en/charset-literal.html

http://dev.mysql.com/doc/refman/5.6/en/charset-applications.html


Comments

Post a Comment

Popular posts from this blog

Java 3D LWJGL collision -

-
i making 3d java game lwjgl library, , wondering how add collision detection, player not go through models. i using obj models. here objloader class, loads models: package renderengine; import java.io.bufferedreader; import java.io.file; import java.io.filenotfoundexception; import java.io.filereader; import java.util.arraylist; import java.util.list; import models.rawmodel; import org.lwjgl.util.vector.vector2f; import org.lwjgl.util.vector.vector3f; public class objloader { public static rawmodel loadobjmodel(string filename, loader loader){ filereader fr = null; try { fr = new filereader(new file("res/"+filename+".obj")); } catch (filenotfoundexception e) { system.err.println("couldn't load file!"); e.printstacktrace(); } bufferedreader reader = new bufferedreader(fr); string line; list<vector3f> vertices = new arraylist<vector3f...
Read more

spring - SubProtocolWebSocketHandler - No handlers -

-
i have ugly error during deploying spring app on jboss. 18:11:16,025 error [org.apache.catalina.core.containerbase.[jboss.web].[default-host].[/consumer]] (msc service thread 1-7) exception sending context initialized event listener instance of class org.springframework.web.context.contextloaderlistener: org.springframework.context.applicationcontextexception: failed start bean 'subprotocolwebsockethandler'; nested exception java.lang.illegalargumentexception: no handlers @ org.springframework.context.support.defaultlifecycleprocessor.dostart(defaultlifecycleprocessor.java:176) [spring-context-4.1.3.release.jar:4.1.3.release] @ org.springframework.context.support.defaultlifecycleprocessor.access$200(defaultlifecycleprocessor.java:51) [spring-context-4.1.3.release.jar:4.1.3.release] @ org.springframework.context.support.defaultlifecycleprocessor$lifecyclegroup.start(defaultlifecycleprocessor.java:346) [spring-context-4.1.3.release.jar:4.1.3.release] @ org.s...
Read more

methods - python can't use function in submodule -

-
my folder structure this: pythonstuff/ program.py modulea/ __init__.py foo.py bar.py here's code bar.py : def hello(): print("hello, world!") here's code program.py : #!/usr/bin/env python3 modulea import bar bar.hello() i run $ python3 program.py somehow error: file "program.py", line 3, in <module> bar.hello() attributeerror: 'module' object has no attribute 'hello' edit: __init__.py file empty. edit2: after trying realized had bar.py in root directory contained hello() method. bar.py in modulea/ directory empty. add it import os __all__ = [] module in os.listdir(os.path.dirname(__file__)): if module != '__init__.py' , module[-3:] == '.py': __all__.append(module[:-3]) the init .py files required make python treat directories containing packages; done prevent directories common name, such string, unintentionally hiding v...
Read more