Convert varying to Text
Hi All, I want to import values from a postgre database using Data Reader. However, some values are in varying format. How can I convert them to text in the Data Reader?
Answers
-
Hi @Thomas Bartmann,
Are you trying to load the varchar field column into a text cube? Usually the data reader should pick up the varchar values as text when you load into a text cube. Does it throw an error in Data Reader logs when you do this?
Thanks,
Samson.0 -
Hi Samson, I trying to load it into entity desription and I get this error:
0 -
Hi Thomas,
This error usually occurs when the server and client encoding differ, and the database driver tries to translate between those two encoding. When it cannot find an equivalent character, this error is thrown. So the server encoding and client encoding should be the same to avoid the error you see.
Type the following commands on your database one by one to check the server and client encodings and change the client encoding from WIN1252 to UTF8:
show server_encoding;
show client_encoding;
set client_encoding to 'utf8';
If this still does not fix the issue, try changing the ODBC PostgreSQL driver to the Board Postgre driver or the PostgreSQL ODBC driver (UNICODE).
Let me know if this fixes the issue.
0
Categories
- All Categories
- 2K Forums
- 1.8K Platform
- 158 Academy
- 324 Resources
- 1 Board Knowledge Base
- 50 Best Practices
- 49 How-To Guides
- 19 Board Advocacy Program
- 191 Blog
- 4 Groups Hub
- 4 About Groups
- New Community Members
- DACH
- Japan
- 4 Community Captains
- 1 About Community Captains
- 2 Meet the Community Captains
- 1 Topics & Thought Starters
- Learn from the Board Captains
- Release Notes
- Academy
- 2 Board Academy
- 8 ILT/VILT Course Catalogue
- 13 e-Learning Course Catalogue
- 4 Academy Forum
- 1.2K Idea Exchange
- 335 Partner Hub
- 94 Support
- 14 FAQ's
- Customer Support Portal
- 54 Support Articles
- BEAP