Timeline for Convert VARCHAR2 to UTF-8 in Oracle 12
Current License: CC BY-SA 4.0
11 events
| when toggle format | what | by | license | comment | |
|---|---|---|---|---|---|
| Oct 27, 2021 at 20:46 | comment | added | Michael Kutz | UTF8 supports emojis. You should be able to test with that. If you still get gibberish, it's your client.👍 | |
| Oct 27, 2021 at 20:07 | comment | added | Joe DiNottra | @mustaccio Ah... so the Oracle engine does not store the character set, but it's something the client must provide at runtime? | |
| Oct 27, 2021 at 18:23 | comment | added | mustaccio | "I assume the engine knows it internally" -- your assumption is wrong. The data might appear as "gibberish" to you if you incorrectly configure your client NLS settings. | |
| Oct 27, 2021 at 18:20 | history | edited | Joe DiNottra | CC BY-SA 4.0 |
edited title
|
| Oct 27, 2021 at 18:07 | comment | added | Joe DiNottra | My bad, I meant UTF-8 instead of Unicode. | |
| Oct 27, 2021 at 18:07 | history | edited | Joe DiNottra | CC BY-SA 4.0 |
deleted 14 characters in body
|
| Oct 27, 2021 at 18:06 | comment | added | Michael Kutz | What's the current character set? Is DB expected to support other languages? | |
| Oct 27, 2021 at 18:01 | comment | added | CommunityBot | Please clarify your specific problem or provide additional details to highlight exactly what you need. As it's currently written, it's hard to tell exactly what you're asking. | |
| Oct 27, 2021 at 18:01 | comment | added | Mark Stewart |
So, not quite sure what those two columns could contain... Greek character set, Japanese? And you want to end up with a Binary Large Object? Please edit and clarify.
|
|
| S Oct 27, 2021 at 17:53 | review | First questions | |||
| Oct 27, 2021 at 18:01 | |||||
| S Oct 27, 2021 at 17:53 | history | asked | Joe DiNottra | CC BY-SA 4.0 |