[PHP-DB] Special Characters
Hi I am a bit of a newbie to some of this... but I have an issue where I need to read in a file that contains German characters and display them in a browser.. It appears the german ß (ss) gets translated etc I have tried get_html_translation_table(HTML_ENTITIES) and htmlentities() I am using the latest PHP 4.3.2 on OSX My example code is: Any help would be great! TIA Daz -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP-DB] Special characters
Fernando, I don't mean you to change the set of your db. I use mysql, it has char(), and I store utf-8 encoded strings. Every utf8 encoded string is made of bytes and every byte can be entered. I don't want to tell that this will work in your case but it won't hurt. iconv extension is good to transform you iso-8859-1 strings to utf8. after retrieving from db just converted them fron unicode. Regards, Andrey - Original Message - From: "Bernain, Fernando G." <[EMAIL PROTECTED]> To: "'Andrey Hristov'" <[EMAIL PROTECTED]>; "Bernain, Fernando G." <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]> Sent: Monday, January 06, 2003 7:31 PM Subject: RE: [PHP-DB] Special characters > I can't modify the character set of my MSSQL... > (Character Set = 1, iso_1 ISO 8859-1 (Latin-1) - Western European 8-bit > character set.) > > And I NEDD the á-é-í-ó-ú-ñ > > Any idea? > > Fernando Bernain > Senior A > Business Process Outsourcing > > KPMG Argentina > Tel: 54 11 4316 5754 > Fax: 54 11 4316 5734 > [EMAIL PROTECTED] > > > > > -Original Message- > From: Andrey Hristov [mailto:[EMAIL PROTECTED]] > Sent: Monday, January 06, 2003 2:30 PM > To: Bernain, Fernando G.; [EMAIL PROTECTED] > Subject: Re: [PHP-DB] Special characters > > > Fernando, > try to store you data in unicode (utf8) for example. > You iconv to transform if it is needed. > > Andrey > > - Original Message - > From: "Bernain, Fernando G." <[EMAIL PROTECTED]> > To: <[EMAIL PROTECTED]> > Sent: Monday, January 06, 2003 7:25 PM > Subject: [PHP-DB] Special characters > > > > I'm working with MSSQL7.0 Apache 1.3.19 and PHP4.2.3 > > When I select a table with this kind of characters: ó The output is > ¢... > > > > I have the same problem with the others vocals (á-é-í-ú) > > > > What can I do??? Forgot the spanish??? > > > > Fernando Bernain > > Senior A > > Business Process Outsourcing > > > > KPMG Argentina > > Tel: 54 11 4316 5754 > > Fax: 54 11 4316 5734 > > [EMAIL PROTECTED] > > > > > > > > > > > > Email Disclaimer > > > > The information in this email is confidential and may be > > legally privileged. > > It is intended solely for the addressee. > > Access to this email by anyone else is unauthorised. > > If you are not the intended recipient, any disclosure, > > copying, distribution > > or any action taken or omitted to be taken in reliance > > on it, is prohibited and may be unlawful. > > When addressed to our clients any opinions or advice > > contained in this email are subject to the terms and > > conditions expressed in the governing KPMG client engagement > > letter. > > > > > > -- > > PHP Database Mailing List (http://www.php.net/) > > To unsubscribe, visit: http://www.php.net/unsub.php > > > > -- > PHP Database Mailing List (http://www.php.net/) > To unsubscribe, visit: http://www.php.net/unsub.php > -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
RE: [PHP-DB] Special characters
I can't modify the character set of my MSSQL... (Character Set = 1, iso_1 ISO 8859-1 (Latin-1) - Western European 8-bit character set.) And I NEDD the á-é-í-ó-ú-ñ Any idea? Fernando Bernain Senior A Business Process Outsourcing KPMG Argentina Tel: 54 11 4316 5754 Fax: 54 11 4316 5734 [EMAIL PROTECTED] -Original Message- From: Andrey Hristov [mailto:[EMAIL PROTECTED]] Sent: Monday, January 06, 2003 2:30 PM To: Bernain, Fernando G.; [EMAIL PROTECTED] Subject: Re: [PHP-DB] Special characters Fernando, try to store you data in unicode (utf8) for example. You iconv to transform if it is needed. Andrey - Original Message - From: "Bernain, Fernando G." <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Monday, January 06, 2003 7:25 PM Subject: [PHP-DB] Special characters > I'm working with MSSQL7.0 Apache 1.3.19 and PHP4.2.3 > When I select a table with this kind of characters: ó The output is ¢... > > I have the same problem with the others vocals (á-é-í-ú) > > What can I do??? Forgot the spanish??? > > Fernando Bernain > Senior A > Business Process Outsourcing > > KPMG Argentina > Tel: 54 11 4316 5754 > Fax: 54 11 4316 5734 > [EMAIL PROTECTED] > > > > > > Email Disclaimer > > The information in this email is confidential and may be > legally privileged. > It is intended solely for the addressee. > Access to this email by anyone else is unauthorised. > If you are not the intended recipient, any disclosure, > copying, distribution > or any action taken or omitted to be taken in reliance > on it, is prohibited and may be unlawful. > When addressed to our clients any opinions or advice > contained in this email are subject to the terms and > conditions expressed in the governing KPMG client engagement > letter. > > > -- > PHP Database Mailing List (http://www.php.net/) > To unsubscribe, visit: http://www.php.net/unsub.php > -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP-DB] Special characters
Fernando, try to store you data in unicode (utf8) for example. You iconv to transform if it is needed. Andrey - Original Message - From: "Bernain, Fernando G." <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Monday, January 06, 2003 7:25 PM Subject: [PHP-DB] Special characters > I'm working with MSSQL7.0 Apache 1.3.19 and PHP4.2.3 > When I select a table with this kind of characters: ó The output is ¢... > > I have the same problem with the others vocals (á-é-í-ú) > > What can I do??? Forgot the spanish??? > > Fernando Bernain > Senior A > Business Process Outsourcing > > KPMG Argentina > Tel: 54 11 4316 5754 > Fax: 54 11 4316 5734 > [EMAIL PROTECTED] > > > > > > Email Disclaimer > > The information in this email is confidential and may be > legally privileged. > It is intended solely for the addressee. > Access to this email by anyone else is unauthorised. > If you are not the intended recipient, any disclosure, > copying, distribution > or any action taken or omitted to be taken in reliance > on it, is prohibited and may be unlawful. > When addressed to our clients any opinions or advice > contained in this email are subject to the terms and > conditions expressed in the governing KPMG client engagement > letter. > > > -- > PHP Database Mailing List (http://www.php.net/) > To unsubscribe, visit: http://www.php.net/unsub.php > -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
[PHP-DB] Special characters
I'm working with MSSQL7.0 Apache 1.3.19 and PHP4.2.3 When I select a table with this kind of characters: ó The output is ¢... I have the same problem with the others vocals (á-é-í-ú) What can I do??? Forgot the spanish??? Fernando Bernain Senior A Business Process Outsourcing KPMG Argentina Tel: 54 11 4316 5754 Fax: 54 11 4316 5734 [EMAIL PROTECTED] Email Disclaimer The information in this email is confidential and may be legally privileged. It is intended solely for the addressee. Access to this email by anyone else is unauthorised. If you are not the intended recipient, any disclosure, copying, distribution or any action taken or omitted to be taken in reliance on it, is prohibited and may be unlawful. When addressed to our clients any opinions or advice contained in this email are subject to the terms and conditions expressed in the governing KPMG client engagement letter. -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
[PHP-DB] special characters in odbc-queries
Hi there, can anyone tell me, how I have to handle special characters in an odbc-query? for example: 'select * from $table where primary-key=\'1\' ' doesn't work because of the dash in primary-key Thx Kobi -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED]