How can IT departments tackle the challenges of a Big Data world? This white paper provides a roadmap to success and helps companies ensure that all their data is safe and secure, no matter if it resides on-premise with physical or virtual machines or in the cloud.
Course Of The Month
3 days, 1 hour left to enrollBecome a Premium Member and unlock a new, free course in leading technologies each month.
Solved
Unicode to Ascii Oracle 10g
Posted on 2013-01-02
I have a view created in Oracle 10g that outputs one field, which is returned Unicode.
My clients have old ODBC drivers that do not recognize Unicode.
How do I convert this field to ASCII ?
My clients have old ODBC drivers that do not recognize Unicode.
How do I convert this field to ASCII ?
[X]
Welcome to Experts Exchange
Add your voice to the tech community where 5M+ people just like you are talking about what matters.
- Help others & share knowledge
- Earn cash & points
- Learn & ask questions
5-
4
2- +1
12 Comments
Active today
Depending on what unicode characters are in the data, it may not be possible. For example, how would you convert a chinese character to simple ascii?
Can you provide some sample data and expected results?
Can you provide some sample data and expected results?
Active today
>>All the data will be ASCII
Then why can't you just select it? an 'A' in a unicode database should be an 'A' when you select it out.
I agree with awking00, let's take a look at your view code.
Then why can't you just select it? an 'A' in a unicode database should be an 'A' when you select it out.
I agree with awking00, let's take a look at your view code.
Active 6 days ago
Once selected in SQL Plus...yeah I get the data...I can't get it from the old odbc driver that msaccess is using
Active today
It is an environment variable Oralce uses (registry in Windows):
http://docs.oracle.com/cd/E11882_01/server.112/e10729/ch3globenv.htm#NLSPG189
http://docs.oracle.com/cd/E11882_01/server.112/e10729/ch3globenv.htm#NLSPG189
Active today
I doubt this will solve the issue since the Unicode is likely coming from the default database characterset but wanted to throw it out there just in case it will trick the ODBC drivers.
The CONVERT sql function:
http://docs.oracle.com/cd/E11882_01/server.112/e26088/functions034.htm#SQLRF00620
The CONVERT sql function:
http://docs.oracle.com/cd/E11882_01/server.112/e26088/functions034.htm#SQLRF00620
Active 6 days ago
Thanks ....just had to find WHERE in the registry...btw it was in ORACLE_ALL_HOMES
Featured Post
This infographic explains ransomware, type of malware that blocks access to your files or your systems and holds them hostage until a ransom is paid. It also examines the different types of ransomware and explains what you can do to thwart this sinister online threat.
Question has a verified solution.
If you are experiencing a similar issue, please ask a related question
Suggested Solutions
| Title | # Comments | Views | Activity |
|---|---|---|---|
| Oracle Date | 6 | 42 | |
| Excel graph in access report | 1 | 34 | |
| Refine Query to only display records with NON-NULL values in BOTH of two expressions | 6 | 27 | |
| Access 2016 Query to text file csv makes my computer do the blue screen of death | 4 | 16 |
As tax season makes its return, so does the increase in cyber crime and tax refund phishing that comes with it
- Phishing
- Email Servers
- Microsoft Access
- Microsoft IIS Web Server
- Email Software
- The Email Laundry
Access custom database properties are useful for storing miscellaneous bits of information in a format that persists through database closing and reopening. This article shows how to create and use them.
Via a live example, show how to restore a database from backup after a simulated disk failure using RMAN.
This video shows how to copy an entire tablespace from one database to another database using Transportable Tablespace functionality.
Suggested Courses
Course of the Month3 days, 1 hour left to enroll
752 members asked questions and received personalized solutions in the past 7 days.
Join the community of 500,000 technology professionals and ask your questions.