Question Authors' Forum

Problem with special chars(ñ) in Python of SQL Questions

 
Picture of Sergi García
Problem with special chars(ñ) in Python of SQL Questions
by Sergi García - Friday, 10 November 2017, 8:29 PM
 

Hi mates! 

I have a problem with special chars in SQL questions with things like PAIS="España" 

 SQLite works fine, but Python of The questions try to codify test as ascii 7 and it doesnt work. 

I did several changes to prototype. I changed how is read and writed to use utf8 in file commands and it works fine, but subprocess.checkoutput has problems with it. (I think cant accept utf8

Does anybody know a solution? 

Picture of Richard Lobb
Re: Problem with special chars(ñ) in Python of SQL Questions
by Richard Lobb - Saturday, 11 November 2017, 7:32 PM
 

Unfortunately there's no solution at present. CodeRunner itself is all UTF-8 compatible but Jobe uses the Runguard sandbox from the DomJudge programming contest server. That enforces 8-bit ASCII.

However, I have been meaning to look into this, so thanks for the reminder. I'll put it on the TODO list for this summer (southern hemisphere). 

Richard