Skip to Content.
Sympa Menu

freetds - Re: [freetds] FreeTDS and out of Memor Error when trying to read diacritics

freetds AT lists.ibiblio.org

Subject: FreeTDS Development Group

List archive

Chronological Thread  
  • From: "James K. Lowden" <jklowden AT freetds.org>
  • To: freetds AT lists.ibiblio.org
  • Subject: Re: [freetds] FreeTDS and out of Memor Error when trying to read diacritics
  • Date: Fri, 27 Apr 2012 10:22:11 -0400

On Thu, 26 Apr 2012 10:14:56 -0400
"Sarr, Nathan" <nsarr AT library.rochester.edu> wrote:

> I was wondering if someone might be able to help me. We are using
> SUSE 11 SP1 64 bit, SQL Server 2008 R2, unixODBC 2.2.12 driver and
> FreeTDS 0.91 and PHP 5.3.8. When retrieving a row with diacritics we
> get a php out of memory error where it is trying to read all of the
> memory in the system.

You want to make sure FreeTDS is encoding the data according to the
client's expectation. The data have an encoding (sometimes incorrectly
recorded) on the server. The client has one too, usually expressed
with LC_LANG etc. FreeTDS converts between the two.

To know what client encoding to use, FreeTDS looks by default to the
environment. That can be overridden by the "client charset" entry in
freetds.conf.

> Looking at the logs for FreeTDS we are getting
> the following error:
>
> util.c:104:logic error: cannot change query state from IDLE to PENDING

I'm starting to rue the day I added that to the log. It's not
indicative of a user-observable problem. It's a reminder to take care
of some tedious housekeeping internal to the system.

Look at the top of your log to make sure FreeTDS is using the character
sets it should be. If it is, you might want to post the whole log
here. Make the session as short as possible to illustrate the issue
clearly.

HTH.

--jkl




Archive powered by MHonArc 2.6.24.

Top of Page