Thread: [adminer-tracker] [ adminer-Bugs and Features-3097662 ] Oracle UTF8 strings displaying as ?
Database management in a single PHP file
Brought to you by:
jakubvrana
From: SourceForge.net <no...@so...> - 2010-10-28 20:43:00
|
Bugs and Features item #3097662, was opened at 2010-10-28 13:42 Message generated for change (Tracker Item Submitted) made by nmsalinas You can respond by visiting: https://sourceforge.net/tracker/?func=detail&atid=1127745&aid=3097662&group_id=264133 Please note that this message will contain a full copy of the comment thread, including the initial issue submission, for this request, not just the latest update. Category: Adminer Group: 3.0.1 Status: Open Resolution: None Priority: 5 Private: No Submitted By: Nissim Salinas (nmsalinas) Assigned to: Jakub Vrána (jakubvrana) Summary: Oracle UTF8 strings displaying as ? Initial Comment: Currently Adminer cannot display UTF8 data coming from an Oracle table. To list/display UTF-8 characters that are in an Oracle table: [a] Inform users that in Windows they need to set an environment variable called NLS_LANG and give it the value AMERICAN_AMERICA.AL16UTF16 (or whatever they need). [b] The Oracle connection string should be: $oCon = new PDO("oci:dbname=//the_machine_ip:the_port_number/the_service_name;charset=AL32UTF8", "the_user_id", "the_user_pwd"); an example for clarity: $oCon = new PDO("oci:dbname=//192.168.0.20:1521/XE;charset=AL32UTF8", "my_user_name_is_babu", "my_password_is_zazu"); What to do in Unix/Linux I have no idea, but that's for *nix experts to figure out... :-) ---------------------------------------------------------------------- You can respond by visiting: https://sourceforge.net/tracker/?func=detail&atid=1127745&aid=3097662&group_id=264133 |
From: SourceForge.net <no...@so...> - 2010-11-19 15:14:59
|
Bugs and Features item #3097662, was opened at 2010-10-28 22:42 Message generated for change (Comment added) made by jakubvrana You can respond by visiting: https://sourceforge.net/tracker/?func=detail&atid=1127745&aid=3097662&group_id=264133 Please note that this message will contain a full copy of the comment thread, including the initial issue submission, for this request, not just the latest update. Category: Adminer Group: 3.0.1 >Status: Closed >Resolution: Fixed Priority: 5 Private: No Submitted By: Nissim Salinas (nmsalinas) Assigned to: Jakub Vrána (jakubvrana) Summary: Oracle UTF8 strings displaying as ? Initial Comment: Currently Adminer cannot display UTF8 data coming from an Oracle table. To list/display UTF-8 characters that are in an Oracle table: [a] Inform users that in Windows they need to set an environment variable called NLS_LANG and give it the value AMERICAN_AMERICA.AL16UTF16 (or whatever they need). [b] The Oracle connection string should be: $oCon = new PDO("oci:dbname=//the_machine_ip:the_port_number/the_service_name;charset=AL32UTF8", "the_user_id", "the_user_pwd"); an example for clarity: $oCon = new PDO("oci:dbname=//192.168.0.20:1521/XE;charset=AL32UTF8", "my_user_name_is_babu", "my_password_is_zazu"); What to do in Unix/Linux I have no idea, but that's for *nix experts to figure out... :-) ---------------------------------------------------------------------- >Comment By: Jakub Vrána (jakubvrana) Date: 2010-11-19 16:14 Message: Fixed in Git. ---------------------------------------------------------------------- You can respond by visiting: https://sourceforge.net/tracker/?func=detail&atid=1127745&aid=3097662&group_id=264133 |
From: SourceForge.net <no...@so...> - 2010-11-26 14:46:57
|
Bugs and Features item #3097662, was opened at 2010-10-28 22:42 Message generated for change (Settings changed) made by jakubvrana You can respond by visiting: https://sourceforge.net/tracker/?func=detail&atid=1127745&aid=3097662&group_id=264133 Please note that this message will contain a full copy of the comment thread, including the initial issue submission, for this request, not just the latest update. >Category: Oracle Group: 3.0.1 Status: Closed Resolution: Fixed Priority: 5 Private: No Submitted By: Nissim Salinas (nmsalinas) Assigned to: Jakub Vrána (jakubvrana) Summary: Oracle UTF8 strings displaying as ? Initial Comment: Currently Adminer cannot display UTF8 data coming from an Oracle table. To list/display UTF-8 characters that are in an Oracle table: [a] Inform users that in Windows they need to set an environment variable called NLS_LANG and give it the value AMERICAN_AMERICA.AL16UTF16 (or whatever they need). [b] The Oracle connection string should be: $oCon = new PDO("oci:dbname=//the_machine_ip:the_port_number/the_service_name;charset=AL32UTF8", "the_user_id", "the_user_pwd"); an example for clarity: $oCon = new PDO("oci:dbname=//192.168.0.20:1521/XE;charset=AL32UTF8", "my_user_name_is_babu", "my_password_is_zazu"); What to do in Unix/Linux I have no idea, but that's for *nix experts to figure out... :-) ---------------------------------------------------------------------- Comment By: Jakub Vrána (jakubvrana) Date: 2010-11-19 16:14 Message: Fixed in Git. ---------------------------------------------------------------------- You can respond by visiting: https://sourceforge.net/tracker/?func=detail&atid=1127745&aid=3097662&group_id=264133 |