• Open Menu Close Menu
  • Apple
  • Shopping Bag
  • Apple
  • Mac
  • iPad
  • iPhone
  • Watch
  • TV
  • Music
  • Support
  • Search apple.com
  • Shopping Bag

Lists

Open Menu Close Menu
  • Terms and Conditions
  • Lists hosted on this site
  • Email the Postmaster
  • Tips for posting to public mailing lists
Re: Query with binary data?
[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

Re: Query with binary data?


  • Subject: Re: Query with binary data?
  • From: Chuck Hill <email@hidden>
  • Date: Wed, 27 May 2015 21:44:02 +0000
  • Thread-topic: Query with binary data?

You will have to check that MySQL will support.  Generally, BLOB and CLOB don’t work in queries.  FrontBase, by example, has BIT and BYTE data types that should work for storage and query.

Chuck


On 2015-05-27, 2:35 PM, "Ken Anderson" wrote:

All,

I’m working on a server that will send push notifications through Apple’s Push Notification service.  I was originally thinking of storing the device token in binary, but then realized that I will have to look up devices by the device token when the feedback service reports an error.

Is there a way to do a query with binary data (using mysql for the DB), or should I just store it as a hex string instead?  Any experience with this?

Thanks,
Ken


_______________________________________________
Do not post admin requests to the list. They will be ignored.
Webobjects-dev mailing list      (email@hidden)
Help/Unsubscribe/Update your Subscription:

This email sent to email@hidden
 _______________________________________________
Do not post admin requests to the list. They will be ignored.
Webobjects-dev mailing list      (email@hidden)
Help/Unsubscribe/Update your Subscription:

This email sent to email@hidden

References: 
 >Query with binary data? (From: Ken Anderson <email@hidden>)

  • Prev by Date: Query with binary data?
  • Next by Date: Re: Active session count increasing with Refuse New Sessions set
  • Previous by thread: Query with binary data?
  • Next by thread: Wonder job stale on jenkins.wocommunity.org?
  • Index(es):
    • Date
    • Thread