java - MySQL - question marks -


when inserting app chinese characters written db '???'. needless works fine within built in command line mysql client.

connection string:

--user-db-uri = jdbc:mysql://localhost/tigasedb?user=tigase_user&password=tigase_passwd&useunicode=true&characterencoding=utf8&noaccesstoprocedurebodies=true

code:

try {             conn_valid_st.setquerytimeout(query_timeout);             st = conn.preparestatement("set character_set_client = utf8");             st.execute();             st.close();             st = conn.preparestatement("set character_set_connection = utf8");             st.execute();             st.close();             st = conn.preparestatement("set character_set_results = utf8");             st.execute();             st.close();             st = conn.preparestatement("set collation_connection = utf8_general_ci");             st.execute();             st.close();             st = conn.preparestatement("set names utf8");             st.execute();             st.close();             st = conn.preparestatement("set character set utf8");             st.execute();             st.close();         } catch (sqlexception ex) {             // ignore now, seems postgresql not support method             // call yet             if (null != st)                 st.close();              log.log(level.warning, "db server said: {0}", ex.tostring());         }

what eludes me ?

edit:

create table ... engine=innodb default character set utf8 collate utf8_unicode_ci row_format=dynamic;

inserted characters: 在健身房

verification done built in command line mysql client.

edit: http://docs.oracle.com/cd/e17952_01/refman-5.0-en/connector-j-reference-charsets.html did not help

check value of system property "file.encoding". if not "utf-8", need explicitly specify "utf-8" character encoding whenever decode bytes characters. example, when call string constructor byte[], or use inputstreamreader.

problems reading/writing utf-8 data in mysql java using jdbc connector 5.1 - did not help

declared string variables in stored procedures _loc varchar(128) charset utf8 - did not help

your database table column should created proper charset , collation. can define theit while creating or altering table:

col_name {char | varchar | text} (col_length)     [character set charset_name]     [collate collation_name]

here mysql link learn more it:

http://dev.mysql.com/doc/refman/5.0/en/charset-column.html


Comments

Post a Comment

Popular posts from this blog

c++ - End of file on pipe magic during open -

i have c++ application in starting process(wireshark) following. if (fp == null){ fp = popen(processpath, "r"); //processpath process want start if (!fp){ throw std::invalid_argument("cannot start process"); } fprintf(fp, d_msg);//d_msg input want provide process } else if(fp != null){ fprintf(fp, d_msg); } the problem when execute c++ application, start wireshark error end of file on pipe magic during open what should avoid that? also tried using mkfifo create named pipe , execute it. used this: if (fp == null){ system("mkfifo /tmp/mine.pcap"); fp = popen("wireshark -k -i /tmp/mine.pcap", "r"); if (!fp){ dout << "cannot start wireshark"<<std::endl; throw std::invalid_argument("cannot start wireshark"); } input = fopen("/tmp/mine.pcap", "wb"); fprintf(input , d_msg); fclose(input)...
Read more

basic authentication with http post params android -

i doing basic authentication passing username , password , using basicnamevaluepair sending post params response service. my method: public stringbuilder callservicehttppost(string username, string password, string type) { // create new httpclient , post header httpclient httpclient = new defaulthttpclient(); httppost httppost = new httppost(webservice + type); httpresponse response = null; stringbuilder total = new stringbuilder(); try { url url = new url(webservice + type); /*string base64encodedcredentials = base64.encodetostring((username + ":" + password).getbytes(), base64.url_safe | base64.no_wrap);*/ string base64encodedcredentials = "basic " + base64.encodetostring( (username + ":" + password).getbytes(), base64.no_wrap); httppost.setheader("auth...
Read more

data.table making a copy of table in R -

i doing this: myfun <- function(inputvar_vec){ # inputvar_vec input vector # # result = output vector return(result) } dt[, result := lapply(.sd, myfun), = byvar, .sdcols = inputvar] i getting following warning: warning message: `in `[.data.table`(df1, , `:=`(prop, lapply(.sd, propeventinlastk)), : invalid .internal.selfref detected , fixed taking copy of whole table, := can add new column reference. @ earlier point, data.table has been copied r (or been created manually using structure() or similar). (and more stuff) .... ` my guess because stacking result vectors (after operation), copy being made? can suggest method remove warning? have done using apply functions , thought should extendable here too. my other question is: can pass chunk of rows data frame (subsetted using statement), , call function myfun operate on that? adding example requested # generate data n = 10000 default=na value = 1 df = data.table(id = sample(1:5000, n, replace=true), ...
Read more