StackOverflow2013

Note that there are some explanatory texts on larger screens.

plurals

PO
text
Body
copied!<p>By default Greenplum use UTF8 for character encoding. You could check this by logging in to Greenplum server and launching psql - console client for Greenplum. In this console application you could issue command: <code>\l</code> to list all of the databases configured in the Greenplum - this should also describe character set for database.</p> <p>I think your prblem is that R doesnt support UTF8 for chars (You use different locale) But you could use On-the-fly transcoding in ODBC driver. Not sure about all ODBC drivers but DataDirect drivers support extra option in odbc.ini file (usually located in user home directory) - IANAAppCodePage. </p> <p>You could find appropriate code for this parameter on this link: <a href="http://www.iana.org/assignments/character-sets" rel="nofollow">http://www.iana.org/assignments/character-sets</a></p> <p>Here is the example od ODBC.ini content:</p> <pre><code>[ODBC] Driver=/opt/odbc/lib/S0gplm60.so IANAAppCodePage=2252 AlternateServers= ApplicationUsingThreads=1 ConnectionReset=0 ConnectionRetryCount=0 ConnectionRetryDelay=3 Database=mysdb EnableDescribeParam=1 ExtendedColumnMetadata=0 FailoverGranularity=0 FailoverMode=0 FailoverPreconnect=0 FetchRefCursor=1 FetchTSWTZasTimestamp=0 FetchTWFSasTime=0 HostName=192.168.1.100 InitializationString= LoadBalanceTimeout=0 LoadBalancing=0 LoginTimeout=15 LogonID= MaxPoolSize=100 MinPoolSize=0 Password= Pooling=0 PortNumber=5432 QueryTimeout=0 ReportCodepageConversionErrors=0 TransactionErrorBehavior=1 XMLDescribeType=-10 </code></pre>

Querying!

Guidance

An individual column

Larger individual text columns get their own page to allow for proper reading.

SQuiL has stopped working due to an internal error.

If you are curious you may find further information in the browser console, which is accessible through the devtools (F12).

Reload