do I need to do something else? I don't have control of what gets placed on the source google calendar, it could be anything, so it'd be nice to use an encoding that plays nice with others
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.
Thanks alister: yes, it turns out you can specify this in the connection, so I added it to the code like:
but now I get syntax error:
which I suspect is because the data from 'content' isn't fitting inside data_point [ 'content' ] very well? In awk/sed/bash this would relate to single/double quotes surrounding a content being put into a variable, not sure in python
Last edited by unclecameron; 09-02-2011 at 05:35 PM..
Looking at your code, the first thing that stands out is that you are using 2-tuples where I suspect it should be a 1-tuple.
Quote:
Originally Posted by unclecameron
data_point[ 'title' ] contains two elements though the intention is to pass only one.
Assuming that the value you want to pass to the query is an_event.title.text, you could either not include i in the tuple or you could index the desired element of the 2-tuple parameter in the execute() call, e.g. data_point['title'][1].
The same goes for data_point[ 'content' ].
Regards,
Alister
---------- Post updated at 05:26 PM ---------- Previous update was at 05:06 PM ----------
Skimming over Writing MySQL Scripts with Python DB-API, it seems that the execute function expects a tuple sequence consisting of each value to be bound, in the order they are to be bound, to the %s placeholders.
Assuming the following code ...
Quote:
Originally Posted by unclecameron
... I believe the proper call to execute() would be:
Although if it were my code, I'd modify the assignment statements to store strings instead of tuples in the data_point dictionary. Instead of:
wow, okay, this really helps me understand, thanks again Alister . Though the pain, I really have learned something, and am very thankful for all the help. The final code, in case anyone wants to do something similar, is listed below:
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)