New topic: Fields in the database with accents
<http://forums.realsoftware.com/viewtopic.php?t=47149> Page 1 of 1 [ 4 posts ] Previous topic | Next topic Author Message adrianoaav Post subject: Fields in the database with accentsPosted: Mon Mar 04, 2013 3:00 pm Joined: Wed Aug 29, 2012 7:54 am Posts: 5 Hello everybody. I have a database in MS Access 2000 on a client that uses some fields with accents, eg "Situação", but I can not change this database for reasons of force majeure. I tried to change the encoding in the query but not getting success. I wonder if anyone can help me because I need to use the field "Situação" as a filter in a query. I thank everyone in advance. Top HMARROQUINC Post subject: Re: Fields in the database with accentsPosted: Mon Mar 04, 2013 7:20 pm Joined: Sun Jan 25, 2009 5:11 pm Posts: 496 Location: Guatemala, Central America You might need to .convertencoding when sending to the database and .defineencoding when reading from the database. Also, after some tesing Encodings.ISOLatin1 was the enconding that worked best for me. _________________ Future RS guru. Ride the world! Top timhare Post subject: Re: Fields in the database with accentsPosted: Mon Mar 04, 2013 7:35 pm Joined: Fri Jan 06, 2006 3:21 pm Posts: 12100 Location: Portland, OR USA Depending on the database, you could try enclosing the field name in backticks "`". where `Situação` = 'some value' Top HMARROQUINC Post subject: Re: Fields in the database with accentsPosted: Mon Mar 04, 2013 8:43 pm Joined: Sun Jan 25, 2009 5:11 pm Posts: 496 Location: Guatemala, Central America I tried that with MySQL with no luck, perhaps it works in Access. _________________ Future RS guru. Ride the world! Top Display posts from previous: All posts1 day7 days2 weeks1 month3 months6 months1 year Sort by AuthorPost timeSubject AscendingDescending Page 1 of 1 [ 4 posts ]
-- Over 1500 classes with 29000 functions in one REALbasic plug-in collection. The Monkeybread Software Realbasic Plugin v9.3. http://www.monkeybreadsoftware.de/realbasic/plugins.shtml [email protected]
