From: <pa...@ti...> - 2005-02-18 13:29:15
|
Jeff Smith wrote: >--- "Pedro A. Aranda Guti=E9rrez" <pa...@ti...> wrote: >+-----------+--------------------------------------------------+----= ----------------------------------------------+ > =20 > >>|IdDirector |Apellidos =20 >>|Nombre | >> >> =20 >> >+-----------+--------------------------------------------------+----= ----------------------------------------------+ > =20 > >>|96 |Previn =20 >>|Andr=C3=A9 | >> >> =20 >> >+-----------+--------------------------------------------------+----= ----------------------------------------------+ > =20 > >>1 Row retrieved >> >>The column 'Nombre' should show Andr=E9. Is there someone working o= n this? >> =20 >> > >It is showing Andr=E9 -- in UTF8. To get it to show up in another e= ncoding, >you need to set the environment variable MDB_ICONV to the encoding y= ou want. >Run 'iconv -l' to see the available encodings. Most people that nee= d it >changed would want ISO-8859-1. > =20 > Thanks a lot. There is a Spanish proverb: "You'll never go to sleep= =20 without having learnt something new" :-) >>Then, I'd also like to point out that mdb-sql is extremely interest= ing=20 >>for many quick >>prototyping applications, but only if it can be used as a coprocess= . For=20 >>that you need >>to add an >> fflush(stdout); >>after every >> fprintf(stdout,"\n"); >> >>I know it sounds tedious, but the application for this is really= =20 >>_great_. I could provide >>a patch for adding this. >> =20 >> > >What information can you give on how you are using it? What are you= doing >that libmdbsql cannot provide? > =20 > I didn't have the time to go through libmdbsql and had mdb-sql runnin= g.=20 So I made this trivial patch and now I am able to write C programs (using tcc I don'= t=20 even need to compile them to do the tests) which access my MDB files via mdb-sql. This can= =20 also apply for people you might want to access MDB using AWK or other scripting languages.= =20 This fflush() over- comes the UNIX limitation of not flushing stdout after a "\n" if stdo= ut=20 is connected to a pipe. It's not that you do something you wouldn't be able to do... it's mor= e=20 the convinience of having a running program and 'connecting' it to other tools. Isn't this what= we=20 all love in **IX OS's ?? :-) Regards, --=20 Pedro Andr=E9s Aranda Guti=E9rrez Telef=F3nica I+D IP Network Access Technologies Consultant mailto:pa...@ti... C./ Emilio Vargas, 6 Tlf +34-91 337 4702 E-28043 Madrid, Spain FAX +34-91 337 4502 Fragen sind nicht da, um beantwortet zu werden. Fragen sind da, um gestellt zu werden - Georg Kreisler |