09-02-2011
My guess would be that the python mysql client has been converting to and sending latin-1 while mysqld has been converting that to utf-8 before writing to the db (since mysqld simultaneously supports different character set/encodings per client connection/per database/server default). This works fine until you have a unicode character that's not part of latin-1.
I suggest fiddling with MySQLdb.connect() parameters. I believe you can set the encoding there and force use of Unicode for returned strings.
Sorry I can't be more specific, but I don't hack with python that much these days and my experience with mysql is quite limited.
Regards,
Alister
This User Gave Thanks to alister For This Post:
10 More Discussions You Might Find Interesting
1. Shell Programming and Scripting
Hi all,
I'm not sure if this is the right forum, but i'll give it a try.
Here is my problem:
i have two files having basically the same things in it (hostnames):
File 1
mituap01
mituap02
mituap03
File 2:
mituap01
mituap04
mituap05
my goal is to get a .py out to check if pcs' in... (0 Replies)
Discussion started by: penguin-friend
0 Replies
2. Shell Programming and Scripting
Hi
i have a variable 'reform' and store the lines like
reform= {
record
string(8) ID;
string(4) PRD;
date("YYMMDD", split = "800101") DateofManufact;
string(4) PRDC_MODULE_NUM;
string(1) END_OF_RECORD = "\n";
}
I need to search for the character "\n"in the above variable... (1 Reply)
Discussion started by: dhanamurthy
1 Replies
3. Shell Programming and Scripting
My question is so simple:
A = raw_input("A ")
if A == '56':
VAR = (A + 54)/13
else:
print "other operations"
if I write in input 5656565656
i want to make some arithmetic operations if the first input is 56XXX
but the output is
TypeError: cannot concatenate 'str' and... (2 Replies)
Discussion started by: kazikamuntu
2 Replies
4. Shell Programming and Scripting
Hi,
I am beginner to Unix.
My requirement is to validate the encoding used in the incoming file(csv,txt).If it is encoded with UTF-8 format,then the file should remain as such otherwise i need to chnage the encoding to UTF-8.
Please advice me how to proceed on this. (7 Replies)
Discussion started by: cnraja
7 Replies
5. Shell Programming and Scripting
I have a file command.txt. It's content are as follows:-
The content of file is actually a command with script name and respective arguments.
arg1 and arg2 are dummy arguments , format : -arg arg_value
test is a argument specifying run mode , format : -arg
In my python code, i read it and... (1 Reply)
Discussion started by: animesharma
1 Replies
6. Shell Programming and Scripting
I want to check if the string is WINDOWS-1251 or UTF-8
can you help me to find the string encoding???
or maybe to get URL Content-Type charset with wget?
this is my function on PHP
function check_utf8($str) {
$len = strlen($str);
for($i = 0; $i < $len; $i++){
$c =... (2 Replies)
Discussion started by: sanantonio7777
2 Replies
7. Shell Programming and Scripting
Hi,
I am trying to remove lines once a string is found till another string is found including the start string and end string. I want to basically grab all the lines starting with color (closing bracket). PS: The line after the closing bracket for color could be anything (currently 'more').... (1 Reply)
Discussion started by: Dabheeruz
1 Replies
8. Shell Programming and Scripting
Hi,
I have a python variable with a value like this :
string = "abc.de.fghijk.com:zyz.ab.fgfijk.com:abc.ef.fghijk.com"
They are hostnames separated by the special character ":" . From this string I want to make a list with values : (2 Replies)
Discussion started by: ctrld
2 Replies
9. Solaris
Hi all!!
I´m using command file -i myfile.xml to validate XML file encoding, but it is just saying regular file . I´m expecting / looking an output as UTF8 or ANSI / ASCII
Is there command to display the files encoding?
Thank you! (2 Replies)
Discussion started by: mrreds
2 Replies
10. Shell Programming and Scripting
Hi I was hoping some one would know if it is possible to url encode a string using sed?
My problem is I have extracted some key value pairs from a text file with sed, and will be inserting these pairs as source variables into a curl script to automatically download some xml from our server.
My... (5 Replies)
Discussion started by: Paul Walker
5 Replies
LEARN ABOUT DEBIAN
dh_pysupport
DH_PYSUPPORT(1) python-support DH_PYSUPPORT(1)
NAME
dh_pysupport - use the python-support framework to handle Python modules
SYNOPSIS
dh_pysupport [debhelper options] [-V X.Y] [-X item [...]] [-n] [module dirs ...]
DESCRIPTION
dh_pysupport is a debhelper program that will scan your package, detect public modules in /usr/lib/pythonX.Y/site-packages, and move them
to the shared Python modules location. It will generate appropriate postinst/prerm scripts to byte-compile modules installed there for all
available python versions.
It will also look for private Python modules and will byte-compile them with the current Python version. You may have to list the
directories containing private Python modules.
If a file named debian/pyversions exists, it is used to determine the python versions with which the package can work.
Appropriate dependencies on python-support, python and pythonX.Y are put in ${python:Depends}. The ${python:Versions} and
${python:Provides} optional substitution variables are made available as well.
OPTIONS
module dirs
If your package installs private python modules in non-standard directories, you can make dh_pysupport check those directories by
passing their names on the command line. By default, it will check /usr/lib/$PACKAGE, /usr/share/$PACKAGE, /usr/lib/games/$PACKAGE and
/usr/share/games/$PACKAGE
-n, --noscripts
Do not modify postinst/postrm scripts.
-d This option is deprecated.
-V X.Y
Force private modules to be bytecompiled with the specific X.Y python version, regardless of the default python version on the system.
-X item, --exclude=item
Exclude files that contain "item" anywhere in their filename from being taken into account to generate the python dependency. It also
excludes them from byte-compilation. You may use this option multiple times to build up a list of things to exclude.
CONFORMS TO
Python policy as of 2006-08-10
SEE ALSO
debhelper(7)
This program is a part of python-support but is made to work with debhelper.
AUTHORS
Josselin Mouette <joss@debian.org>, Raphael Hertzog <hertzog@debian.org>
1.0.15 2012-06-30 DH_PYSUPPORT(1)