Hi
I have a table in SQL_ASCII. Clients with different language versions of
Windows can write data in tha table using different coding systems (polish,
english, cyrillic). Next i would like to convert each line of given column
to UTF8, but each row can use a different coding windows-125*.
Who
Travis Whitton wrote:
SELECT keyword FROM keywords WHERE keyword like 'foo%';
Are there any other functions that can provide equivalent results while
using an index, or am going to have drop UTF-8 and recreate my database?
UTF-8 isn't your locale, it's your character set (or encoding). Your
From everything I've been able to find, it seems that the only way to get
front-anchored regular expressions or LIKE patterns beginning with constants
to use an index is to have previously initialized your database using the C
locale. Is this still true? I'm trying to do something like:
SELECT k
--- Andreas Kretschmer <[EMAIL PROTECTED]> wrote:
> Richard, the plain SQL "INSERT INTO " is an other thing as the
> original problem...
>
> He is in a PL/pgsql - function and he should rewrite this to use EXECUTE
> ... INTO
>
I see, I am not even a novice yet when it comes PL/pgsql. Thanks f
Mulham freshcode <[EMAIL PROTECTED]> writes:
>Am new to sql scripting so this might be a stupid question. Am getting an
> error while trying to do the following
> SELECT INTO svc_data_rec * from svc_tbl_name where 'uid' = sub_id;
The error message shows that this is getting rewritten into
>
Richard Broersma Jr <[EMAIL PROTECTED]> schrieb:
> > Hi guys,
> >
> >Am new to sql scripting so this might be a stupid question. Am getting
> > an error while trying
> > to do the following
> >
> > SELECT INTO svc_data_rec * from svc_tbl_name where 'uid' = sub_id;
> >
> > where svc_data_
> Hi guys,
>
>Am new to sql scripting so this might be a stupid question. Am getting an
> error while trying
> to do the following
>
> SELECT INTO svc_data_rec * from svc_tbl_name where 'uid' = sub_id;
>
> where svc_data_rec is defined as record and svc_tbl_name is a varchar that
> holds
am Wed, dem 22.11.2006, um 0:28:15 -0800 mailte Mulham freshcode folgendes:
> Hi guys,
>
>Am new to sql scripting so this might be a stupid question. Am getting an
> error while trying to do the following
>
> SELECT INTO svc_data_rec * from svc_tbl_name where 'uid' = sub_id;
>
> where svc
Hi guys,
Am new to sql scripting so this might be a stupid question. Am getting an
error while trying to do the following
SELECT INTO svc_data_rec * from svc_tbl_name where 'uid' = sub_id;
where svc_data_rec is defined as record and svc_tbl_name is a varchar that
holds the name of a table
