Alter session to NLS_CHARACTERSET.

[targinosilveira]

Good afternoon friends, I'm here looking for a little help from you, I have a developing application, it is being done in php, and we are with a small problem, is that the scheme we are using this on a bench with the encoding pattern of written for ISO-8959-1 and I need to pass the data in UTF-8 format, because when accented data on return they return half "awkward" hehehe, as the bank already has other schemas working cool without problems I do not want to risk of them.

So I think I could make use of alter session and set the new settings only in the section in use and when sending the data and then recovering them normally, is this possible? If yes, what would be the command line I use because I tried the following and gave error:

alter session set nls_characterset = 'AL32UTF8';

In advance, thank you any response.




Environment information:
* Oracle version: 10g
* Operating system: Windows Server 2003

[gilbertoca]

Good afternoon friends, I am here looking for a little help from you, I have a developing application, it is being done in PHP, and we are with a small problem, is that the scheme we are using this Bank with writing encoding pattern for ISO-8959-1 and I need to pass the data in UTF-8 format, because when accentuated data on return they return half "awkward" hehehe, as the bank already has other legal working schemas No problems I do not want to risk tinkling their standard.

So I think I could make use of alter session and set the new settings only in the section in use and when sending the data and then recovering them normally, is this possible? If yes, what would be the command line I use because I tried the following and gave error:


in advance, thank you any response.




Environment information:
* Oracle version: 10g
* Operating system: Windows Server 2003

See, there is something you did not notice! The ISO-8959-1 character set is a subset of UTF8, that is, you are wanting to put something in ISO-8959-1 that would only fit in UTF8. Did you get there, the cucumber?
Creating a database is not something that is done anyway. When developer, he had this simplistic view of the thing and I ended up having several headaches because of this bad conception.

If the storage of this information is essential, I suggest the backup of the current bank, an Export Full, the creation of a new bank with the appropriate character set and finally an import.

Gilberto

[targinosilveira]

beleza Gilberto, what I'm doing now in the morning is:
I created a new bank test machine with the character set UTF-8 and after the tests giving everything ok, I'll do the other machine and an IMP New to see if there is no buxo, Hhehe.

But it was worth my friend !!!

Hugs !!