Is there a way to search for a character in the database by the
hexidecimal value of that character?
--
Until later, Geoffrey
"I predict future happiness for America if they can prevent
the government from wasting the labors of the people under
the pretense of taking care of them."
- Thomas Jef
yes, there is.
select from where
like '%'||chr(x'42'::int)||'%'
where '42' is your hexadecimal character value.
Be sure to read and understand everything you can find about encodings; and
make sure the hexadecimal value you are searching for is from the same
encoding.
Best wishes,
Harald
We need to change the database encoding on our databases as they were
created with the wrong encoding. They were created as SQL_ASCII and we
are changing them to UTF8.
When testing this Friday, I received the following error:
pg_restore: [archiver (db)] Error while PROCESSING TOC:
pg_restore:
Massa, Harald Armin wrote:
yes, there is.
select from where
like '%'||chr(x'42'::int)||'%'
This does not work for me, but if I convert the hex value to octal this
does work:
select comments from fax where comments ~* E'\231';
where '42' is your hexadecimal character value.
Be sure t
I have been fighting with a select and can find no satisfactory solution.
Simplified version of the problem:
A table that, in reality, log state changes to an object (represented as
a row in another table):
CREATE TABLE t (
id SERIAL UNIQUE,
ref INTEGER, -- Reference to a row in anoth
On Monday 24 January 2011 6:38:55 am Geoffrey Myers wrote:
> We need to change the database encoding on our databases as they were
> created with the wrong encoding. They were created as SQL_ASCII and we
> are changing them to UTF8.
>
> When testing this Friday, I received the following error:
>
>
Fredric Fredricson writes:
> ... Now I want the latest "someData" for each "ref" like:
> The best solution I could find depended on the fact that serial is
> higher for higher dates. I do not like that because if that is true, it
> is an indirect way to get the data and could possibly, in the f
Adrian Klaver wrote:
On Monday 24 January 2011 6:38:55 am Geoffrey Myers wrote:
We need to change the database encoding on our databases as they were
created with the wrong encoding. They were created as SQL_ASCII and we
are changing them to UTF8.
When testing this Friday, I received the follo
On Jan 24, 2011, at 10:50 AM, Fredric Fredricson wrote:
> I have been fighting with a select and can find no satisfactory solution.
>
> Simplified version of the problem:
>
> A table that, in reality, log state changes to an object (represented as a
> row in another table):
>
> CREATE TABLE t
On Monday 24 January 2011 7:57:52 am Geoffrey Myers wrote:
> Adrian Klaver wrote:
> > On Monday 24 January 2011 6:38:55 am Geoffrey Myers wrote:
> >> We need to change the database encoding on our databases as they were
> >> created with the wrong encoding. They were created as SQL_ASCII and we
>
Adrian Klaver wrote:
On Monday 24 January 2011 7:57:52 am Geoffrey Myers wrote:
Adrian Klaver wrote:
On Monday 24 January 2011 6:38:55 am Geoffrey Myers wrote:
We need to change the database encoding on our databases as they were
created with the wrong encoding. They were created as SQL_ASCII
On Monday 24 January 2011 8:06:38 am Geoffrey Myers wrote:
> Adrian Klaver wrote:
> > On Monday 24 January 2011 7:57:52 am Geoffrey Myers wrote:
> >> Adrian Klaver wrote:
> >>> On Monday 24 January 2011 6:38:55 am Geoffrey Myers wrote:
> We need to change the database encoding on our databases
Adrian Klaver wrote:
On Monday 24 January 2011 8:06:38 am Geoffrey Myers wrote:
Adrian Klaver wrote:
On Monday 24 January 2011 7:57:52 am Geoffrey Myers wrote:
Adrian Klaver wrote:
On Monday 24 January 2011 6:38:55 am Geoffrey Myers wrote:
We need to change the database encoding on our datab
On Mon, Jan 24, 2011 at 12:16:46PM -0500, Geoffrey Myers wrote:
> We hope to identify the characters and fix them in the existing
> database, then convert. It appears to be very limited, but it would
> help if there was some way to identify these characters outside of
> simply doing the relo
On 01/24/2011 09:16 AM, Geoffrey Myers wrote:
We hope to identify the characters and fix them in the existing
database, then convert. It appears to be very limited, but it would help
if there was some way to identify these characters outside of simply
doing the reload of the data and finding th
On 01/24/2011 04:56 PM, Tom Lane wrote:
Fredric Fredricson writes:
... Now I want the latest "someData" for each "ref" like:
The best solution I could find depended on the fact that serial is
higher for higher dates. I do not like that because if that is true, it
is an indirect way to get the d
Adrian Klaver wrote:
On 01/24/2011 09:16 AM, Geoffrey Myers wrote:
We hope to identify the characters and fix them in the existing
database, then convert. It appears to be very limited, but it would help
if there was some way to identify these characters outside of simply
doing the reload of t
On 01/24/2011 05:02 PM, A.M. wrote:
On Jan 24, 2011, at 10:50 AM, Fredric Fredricson wrote:
I have been fighting with a select and can find no satisfactory solution.
Simplified version of the problem:
A table that, in reality, log state changes to an object (represented as a row
in another t
I have cleaned up my simple Perl cgi script for accessing Postgresql db's...
Thanks to Tom Lane's (aka the Wizard) hints the 'describe ' function
now works :)
The url: http://homepage.mac.com/levanj/Perl
I also found a mac php package that has postgresql support ( My mac php systems
do *not
On 01/24/2011 03:19 AM, Ben Chobot wrote:
On Jan 23, 2011, at 3:29 AM, Attila Nagy wrote:
Hello,
I'm looking for a database backend for a dictionary coder project. It would
have three major tasks:
- take a text corpus, get their words and substitute each word by a 64 bit
integer (the word:i
On 01/24/2011 05:27 AM, Fredric Fredricson wrote:
I can easily do this with any RDBMS, with a table of three columns:
auto incremented ID, word and refcount, with a unique index on word.
The challenge could be:
- that it should scale to several TBs of size and several (hundred)
billion of re
On 01/24/2011 10:57 AM, Geoffrey Myers wrote:
Adrian Klaver wrote:
On 01/24/2011 09:16 AM, Geoffrey Myers wrote:
We hope to identify the characters and fix them in the existing
database, then convert. It appears to be very limited, but it would help
if there was some way to identify these cha
~
I need to configure postgreSQL in a way that I could run it from a
directory mounted as read only, with separate rw partitions mounted
for the data, logs, . . .
~
What would be the steps to follow and the issues to take into consideration?
~
thanks
lbrtchx
--
Sent via pgsql-general mailing
... better yet; is it possible to configure postgreSQL in a way that
it depends on external variables set via the OS in the same process
in which it is started?
~
lbrtchx
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.post
24 matches
Mail list logo
