[DiscordArchive] So that would be a matter of fixing the packet parser to output SQL scripts with " as quotes , no?
[DiscordArchive] So that would be a matter of fixing the packet parser to output SQL scripts with " as quotes , no?
Original source
So that would be a matter of fixing the packet parser to output SQL scripts with " as quotes , no?
rektbyfaith
02-18-2024, 08:53 PM #1Archived author: chipzz • Posted: 2024-02-18T20:53:51.410000+00:00
Original source
So that would be a matter of fixing the packet parser to output SQL scripts with " as quotes , no?
Original source
That is, of course, if using ANSI mode doesn't preclude using @ variables
rektbyfaith
02-18-2024, 08:56 PM #2Archived author: chipzz • Posted: 2024-02-18T20:56:06.229000+00:00
Original source
That is, of course, if using ANSI mode doesn't preclude using @ variables
Original source
You could also just convert scripts before you import them (during which you could also just convert the uint64 values) - how to know which ones those are: ask the database what types the columns are, the job fitting ones are those which need converting (or if there are just a few and they change rarely, call them out in the converting script)
rektbyfaith
02-18-2024, 08:58 PM #3Archived author: kjarex • Posted: 2024-02-18T20:58:32.102000+00:00
Original source
You could also just convert scripts before you import them (during which you could also just convert the uint64 values) - how to know which ones those are: ask the database what types the columns are, the job fitting ones are those which need converting (or if there are just a few and they change rarely, call them out in the converting script)
Original source
and wrt to uint64; basically UUIDs (if I get that correct) are essentially 64-bit values
rektbyfaith
02-18-2024, 08:59 PM #4Archived author: chipzz • Posted: 2024-02-18T20:59:23.414000+00:00
Original source
and wrt to uint64; basically UUIDs (if I get that correct) are essentially 64-bit values
Original source
And I suspect you'll have a lot of columns containing UUIDs
rektbyfaith
02-18-2024, 08:59 PM #5Archived author: chipzz • Posted: 2024-02-18T20:59:37.356000+00:00
Original source
And I suspect you'll have a lot of columns containing UUIDs
Original source
(I may be mistaken)
rektbyfaith
02-18-2024, 08:59 PM #6Archived author: chipzz • Posted: 2024-02-18T20:59:48.820000+00:00
Original source
(I may be mistaken)
Original source
you are
rektbyfaith
02-18-2024, 09:00 PM #7Archived author: Tea • Posted: 2024-02-18T21:00:01.388000+00:00
Original source
you are
Original source
postgres has an actual uuid type which is 16 bytes
rektbyfaith
02-18-2024, 09:00 PM #8Archived author: Tea • Posted: 2024-02-18T21:00:12.862000+00:00
Original source
postgres has an actual uuid type which is 16 bytes
Original source
I meant the WoW UUID type, not the postgres one
rektbyfaith
02-18-2024, 09:00 PM #9Archived author: chipzz • Posted: 2024-02-18T21:00:40.945000+00:00
Original source
I meant the WoW UUID type, not the postgres one
Original source
And postgresql also supports flags out of the box
rektbyfaith
02-18-2024, 09:00 PM #10Archived author: kjarex • Posted: 2024-02-18T21:00:45.577000+00:00
Original source
And postgresql also supports flags out of the box
1 Guest(s)
1 Guest(s)