tds-fdw / tds_fdw

A PostgreSQL foreign data wrapper to connect to TDS databases (Sybase and Microsoft SQL Server)
Other
357 stars 99 forks source link

Data is broken when checking data using tds_fdw #334

Open MINSIKKANG opened 1 year ago

MINSIKKANG commented 1 year ago

Issue report

The following information is very important in order to help us to help you. Omission of the following details cause delays or could receive no attention at all.

Operating system

On recent GNU/Linux distributions, you can provide the content of the file /etc/os-release

Replace this with the content

Version of tds_fdw

From a psql session, paste the outputs of running \dx

If you built the package from Git sources, also paste the output of running git log --source -n 1 on your git clone from a console

Replace this with the output

Version of PostgreSQL

From a psql session, paste the output of running SELECT version();

Replace this with the output

Version of FreeTDS

How to get it will depend on your Operating System and how you installes FreeTDS

From a console:

Replace this with the output

Logs

Please capture the logs when the e rror you are reporting is happening, as well as commands with their outputs if you are reporting a problem build or installing

_For problems using tdsfdw on PostgreSQL how to do it will depend on your system, but if your PostgreSQL is installed on GNU/Linux, you will want to use tail -f with the log of the PostgreSQL cluster

For MSSQL you will need to use the SQL Server Audit Log

Replace this with the commands an
![image](https://user-images.githubusercontent.com/108848567/234194355-d190b6b7-d572-44ec-b92f-5e0fdead9854.png)
d outputs

Sentences, data structures, data

This will depend on the exact problem you are having and data privacy restrictions

However the more data you provide, the more likely we will be able to help

As a bare minimum, you should provide

KakaoTalk_20230425_153920371
Replace this with the SQL sentences, data structures, etc

Hi, I am working as a postgresql administrator. When I checked the sybase data with tds_fdw, it seemed that the Korean language did not support it

KakaoTalk_20230425_153920371